New idea : Possibility to “tag” filter(s) as mandatory to have results in the dashboard.
- Some Dashboards get a lot of Data if no filter is set.
- Filter is a business value, not a date, so it’s not possible to set a default value.
You have to click on “apply filter” button to get the result, the page is not reloaded dynamically when you set a filter.
When you open the dashboard, no result is got.
The button will appear if one or more filters are tagged as “mandatory” without default value
If your questions are Native/SQL, then you can set the filters to be Required in the question.
There’s a request for having a “run” button - instead of dynamically updating on each filter change:
https://github.com/metabase/metabase/issues/9871 - upvote by clicking on the first post
Thank you for your response.
Your proposition could work if we had the possibility to choose AND or OR constraint between question filters. But for now, it’s just “AND” condition. (Not in SQL request - in configuration)
I have 4 required filters. If one (or more) of them is filled, we can get results, not all of them.
@bencmoi That would either require giving the option to do Custom Expression filters on the dashboard, or have a rather complex dashboard filter options.
You are welcome open a feature request - keep it to one request per issue, and adding clear description, images and use-case will help a lot.
EDIT: There's now a request for required/mandatory filters on dashboards:
https://github.com/metabase/metabase/issues/18097 - upvote by clicking on the first post