It's not possible to create a dashboard filter using formulas. I could create a dashboard filter only with variables that are present in a data source. I am able to create a value in pivot table an...
dashboard filter using formulas
daat
06-25-2025Cloud Apps
How do you create such a filter at dashboard level (not widget level)?
My biggest problem is to be able to create a filter on a field that does not exist as such in the datamodel (but can be created with a formula) and use this filter across different widgets, not just a particular one. It needs to be a dashboard filter, as you mention, but I haven´t been able to create a dashboard filter with formulas.
Thanks for your help!
wallingfordce
06-25-2025Data Pipeline
Not sure I'm following the use case, so may need more detail, but here's an example. The dashboard is filtered to only Brands with a Total Quantity > 0. The left widget ignores the dashboard filter for context of what's being removed by the dashboard filter in the right widget.
- daat07-09-2025Cloud Apps
We tried this and it WORKS great! Thanks for sharing.
The only downside it that once the filter is defined, the formula can´t be changed (e.g. if the user would want to change the value in the formula).