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
- 10.5K All Categories
- 5 Connect
- 915 Connectors
- 250 Workbench
- 459 Transform
- 1.7K Magic ETL
- 69 SQL DataFlows
- 476 Datasets
- 186 Visualize
- 250 Beast Mode
- 2.1K Charting
- 11 Variables
- 16 Automate
- 354 APIs & Domo Developer
- 88 Apps
- 3 Workflows
- 20 Predict
- 5 Jupyter Workspaces
- 15 R & Python Tiles
- 245 Distribute
- 62 Domo Everywhere
- 242 Scheduled Reports
- 20 Manage
- 41 Governance & Security
- 170 Product Ideas
- 1.2K Ideas Exchange
- 10 Community Forums
- 27 Getting Started
- 14 Community Member Introductions
- 55 Community News
- 4.5K Archive