Hi Folks –
I’m relatively new to Metabase and also a SQL novice, so it’s entirely likely this one’s on me…
I’m trying to use field filters to drill down using variables as field filters. The filter dropdown is correctly showing values for the field, but the returned result set is empty – I know this is incorrect, since there are values I can get to in other ways, and this has happened regardless of which field I’ve tried to use in a query.
I checked in the Admin>>Data Model for the specific field, and it is set to “category” by default, and the only available widget choices in the filter for that field filter are “Category” and “None” – neither returns a satisfactory value.
We’re using version 0.2.7.1, with a MySQL back end.
Any help figuring out what the problem is would be greatly appreciated.