Is there a way to make filters inter dependent?
So if I choose a value in filter 1, the options in filter 2 should be updated accordingly and show values relevant only to filter 1
I think so; look at the docs on “Faceted filters”:
1 Like
Yep as @klawecki says, above the concept is called faceted filters. This behaviour filters all suggestions on a given filter based on the other selected filters. For example if I have a country filter and a state filter. If country is set to USA I will only have US states suggested for the state filter.
You can configure this behaviour at a model level or at a dashboard level. The default behaviour is that they are turned off.
For individual dashboards
If you want to turn them on for a dashboard, go to Edit → Settings and turn on Facet filters.
For the the workbook.
You can add facet_workbook_filters: true to your model file to enable faceted filtering in workbooks
1 Like
Thank you! that worked!