Filter doesn't propose a list

Hello !

I have a data source transactions, with the column transaction_type, when I create a question from this data source and add filter on this column I have a list of item.

I have a SQL question, based on this data source : deduplicated_transactions, when I create a question from this SQL question, I don't have a list of items, I have to write them one by one if I want to filter on them.

Is it normal or am I missing something ?

Hi @madeleine_jln
You'll have to use a Model where you map the column to a field to show a dropdown.
https://www.metabase.com/docs/latest/data-modeling/models
It would require something like this to automatically do it directly on SQL:
https://github.com/metabase/metabase/issues/5594 - upvote by clicking :+1: on the first post

1 Like