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
- 303 Workbench
- 6 Cloud Amplifier
- 9 Federated
- 2.9K Transform
- 104 SQL DataFlows
- 640 Datasets
- 2.2K Magic ETL
- 4K Visualize
- 2.5K Charting
- 767 Beast Mode
- 70 App Studio
- 43 Variables
- 716 Automate
- 185 Apps
- 461 APIs & Domo Developer
- 56 Workflows
- 14 DomoAI
- 39 Predict
- 16 Jupyter Workspaces
- 23 R & Python Tiles
- 402 Distribute
- 116 Domo Everywhere
- 277 Scheduled Reports
- 9 Software Integrations
- 134 Manage
- 131 Governance & Security
- 8 Domo Community Gallery
- 44 Product Releases
- 12 Domo University
- 5.4K Community Forums
- 40 Getting Started
- 30 Community Member Introductions
- 111 Community Announcements
- 4.8K Archive