How to make FILTER ALLOW clause dynamic?

Hello all,
I want to make it so that a user can decide on what columns that a particular chart could be filtered on. For example:
SUM(SUM(Website Engagements
)) FIXED (FILTER ALLOW (case when Allow Filtering - Website
= 'Mobile Device Type' then Mobile Device Type
else Mobile Device Type
end))
This is a fixed function with the purpose of using a variable called "Allow Filtering - Website" that is a very simple beastmode that just allows the user to be able to filter on Mobile Device Type if they wanted to. The idea is to expand past just one column in the future. But the main issue is that this doesn't work. When I try filtering by mobile device type when this is enabled and the variable selection is on mobile device type then there is still no filtering that happens… Yet, when I hardcode the call to the mobile device type column it works. But I want to make it so it is dynamic
The idea is to allow users the flexibility of choosing which columns they don't want this metric to be filtered by. Any ideas to fix this?
Thanks,
Brady
Answers
-
Have you tried taking the CASE statement outside of your FILTER ALLOW clause and surround your entire fixed window function in the CASE statement based on the variable?
**Was this post helpful? Click Agree or Like below**
**Did this solve your problem? Accept it as a solution!**0
Categories
- All Categories
- 1.9K Product Ideas
- 1.9K Ideas Exchange
- 1.6K Connect
- 1.3K Connectors
- 306 Workbench
- 6 Cloud Amplifier
- 9 Federated
- 3K Transform
- 112 SQL DataFlows
- 649 Datasets
- 2.2K Magic ETL
- 4K Visualize
- 2.5K Charting
- 787 Beast Mode
- 78 App Studio
- 43 Variables
- 742 Automate
- 187 Apps
- 474 APIs & Domo Developer
- 67 Workflows
- 14 DomoAI
- 40 Predict
- 17 Jupyter Workspaces
- 23 R & Python Tiles
- 406 Distribute
- 117 Domo Everywhere
- 279 Scheduled Reports
- 10 Software Integrations
- 139 Manage
- 136 Governance & Security
- 8 Domo Community Gallery
- 44 Product Releases
- 12 Domo University
- 5.4K Community Forums
- 40 Getting Started
- 30 Community Member Introductions
- 113 Community Announcements
- 4.8K Archive