I'm not sure if it's a bug or a question.
I want to add an age_group variable to my query to use it as a filter in my dashboard.
I'm using this syntax in my WHERE clause:
Then select Filed Filter, and select the right column/table.
The filter recognise the values but when are run the query again I get this message:
(conn=670010) Unknown column 'weekly_p2p_testing_metrics.age_group' in 'where clause'
Please note that the same process work for other tables. It seems like the issue occurs only with this specific table.
I would appreciate any help on this.
Please post "Diagnostic Info" from Admin > Troubleshooting.
Without seeing the entire query, it's hard to tell, but I'm guessing that you are using table aliases, which are not supported for Field Filters:
https://github.com/metabase/metabase/issues/3324 - upvote by clicking on the first post
That was the issue, my table had an alias.
Thank you for your help and quick answer!