I have run into an issue with Dashboard filters in v0.33.2.
For some reason, Metabase shows "no available" fields when I try to assign a Dashboard filter to a Simple question based on a MySQL view.
At the same time, Dashboard filters work correctly with a Question based on the MySQL table.
Example:
MySQL View-based Simple question built with Metabase builder (no custom code):
Hi @dtroyan
I’m not sure how, but notice the order of the Filter and Summarize sections between the working and non-working question.
Try re-doing the non-working question and first define the Filter and then Summarize.
If you can provide steps-to-reproduce for how the order was set to Summarize and then Filter, then please provide those steps, since that seems like a bug.
@flamber, actually, I've noticed that setting up a Metric filter also makes it impossible to use Dashboard filters on the Question. Even if the operations order is the following:
@dtroyan
Great. Thanks for the steps-to-reproduce!
When using the Editor, it can quickly become tricky, since you can do table joins and havings.
Notice the Filter-icon right below the Data-section - that’s the filter you’re interested in.
If you use the bottom filter, then it will make a filter on the summarized data - and to that, it’s doing a sub-query, which is messing with your dashboard filters.
@maz Very similar to what I reported in the previews. Not sure if something needs to be explained differently or documentation should cover this?