Beast mode to select all the slicers
I have a column that populates the below 7 options, I would want to have another option 'All' which displays numbers of all 7 cases instead of manually selecting all 7.
I am trying to write a below beast mode for the same but the 'All' option would not include all of the cases.
case
when combination
= 'desktop' then 'desktop'
…
when combination
in ('desktop','android','ios','desktop_ios','android_desktop','android_ios','android_ios_desktop') then 'All'
Answers
-
@chetan_cricut I recommend creating a variable with the Pills control type and values for all 7 options, plus an “All” option. Then you can create a beast mode filter based on the value selected:
case when
Variable
= ‘All’ then ‘Include’ whenVariable
=combination
then ‘Include’ else ‘Exclude’ end0 -
@MichelleH how does this help me get the 8th variable with all 7 values?
0 -
@chetan_cricut Based on your originial question, my understanding is that you wanted the users to be able to select a single “All” option to filter to all 7 values of the combination field. Is that not the case?
0 -
@MichelleH yes, but when we create 'All' option how does domo understand if all 7 needs to be accounted?
Below is what I have managed to create, beast mode on left and control variable on the right. Not sure how this would function though.
0 -
@chetan_cricut The Include/Exclude filter should not be a slicer, you would need to save it to every card on the dashboard so each card is filtered to ‘Include’.
0 -
@MichelleH just to clarify I currently have 2 beast modes. The one on the left has multi select option(multi select is required for business use). I want to add the 'All' option to be part of the slicer on the left with a feature to include all 7 cases.
Here is the beast mode I have used for ‘All’
case
whencombination
in ('desktop','android','ios','desktop_ios','android_desktop','android_ios','android_ios_desktop') then 'All'
elsecombination
end0
Categories
- All Categories
- 1.8K Product Ideas
- 1.8K Ideas Exchange
- 1.5K Connect
- 1.2K Connectors
- 296 Workbench
- 6 Cloud Amplifier
- 8 Federated
- 2.9K Transform
- 100 SQL DataFlows
- 614 Datasets
- 2.2K Magic ETL
- 3.8K Visualize
- 2.5K Charting
- 729 Beast Mode
- 53 App Studio
- 40 Variables
- 677 Automate
- 173 Apps
- 451 APIs & Domo Developer
- 45 Workflows
- 8 DomoAI
- 34 Predict
- 14 Jupyter Workspaces
- 20 R & Python Tiles
- 394 Distribute
- 113 Domo Everywhere
- 275 Scheduled Reports
- 6 Software Integrations
- 121 Manage
- 118 Governance & Security
- Domo Community Gallery
- 32 Product Releases
- 10 Domo University
- 5.4K Community Forums
- 40 Getting Started
- 30 Community Member Introductions
- 108 Community Announcements
- 4.8K Archive