I am creating a dashboard wherein I’d want a user to be able to flick between two views easily – however each view requires selecting 3 items that fall under a dimension named line. Line can be equal to = this year, last year, targets, % var, and % change.
Each dashboard should have our dimension “line” filtered to 3 items.
Dashboard 1: this year, last year, & % change.
Dashboard 2: this year, target, & % var.
I want to create a ‘rollup’ filter that’ll be named YoY OR vs. target that’ll apply these filters without a user needing to know to filter line to 3 options.
I’ve read this documentation + this too but nothing has worked. I’ve found something on discourse too, but it involves a case statement, the problem I’m finding is that they all tend to apply to thresholds of measures/how to handle a measure (min/max/etc) as opposed to just rolling up a few filter selections into one master one…?
Is there an easier way of doing this, please?
The first thing that comes to mind here is using a sql_always_where: at the model level and some liquid if logic to flick several filters on/off based on the state of a filter.
If you define a parameter
then you can reference it in the explore:
I’m not sure if I fully understand your use case, but I hope this sql_always_where idea might be useful! Would be curious to hear what you wind up with.