Reproducing the problem:
- Create a "native sql query", and save it.
- Navigate through: Ask_a_question>Custom question>Saved question and select the query saved in 1.
- Create a new question and summarize or filter as needed.
- Add it to a dashboard
(I go through steps 1 to 3 because only writing a "native sql query" does not allow the use of Metabase GUI. However, asking a question allows the use of GUI to easily summarize and filter the data) For example: the following shows that I can use the graphical query builder on a sql query by using steps 1 to 3.
The issue is that I cannot find all the fields/columns from the custom query when adding a dashboard filter. The dashboard filter shows only a few columns from the query (not all the available ones) although I am able to filter using the fields using the graphical query builder.
The above image shows a part of all the filters I can apply using the query builder. The following shows the list of columns that I can filter by when using the dashboard.
The Booking Channel column in the above images is no different from the other columns in terms of the data type.
What can I do to fix the issue, so that the dashboard filter includes all the fields that are available?