Using Beast Mode to filter on multiple values?
Since using Domo, I've come across multiple scenarios where I need to filter fields based on multiple columns, and I haven't found an easy way to do this in card building. So far, I've resorted to hard filtering everything out using the ETL, but that isn't very flexible.
Here's an example of what I'm trying to filter:
Activity Type = All and State = All
Except
Activity type = Sequence and State = Finished.
I want to display all of the other data in my Activity Type column, but I want Sequence filtered to only State=Finished (I don't want other activities filtered to Finished).
This is what I tried, but it filtered everything:
"Case when `Activity Type`= 'sequence' and `State`= 'finished'
then 1
else 0
end"
Answers
-
Hi @nshively
There isn't a great way to link filters together except for using a beast mode and defining your conditions like you're doing.
You just need an additional condition in your case statement and change your default value:
CASE WHEN `Activity Type` = 'sequence' AND `State`= 'finished' THEN 1 -- You could exclude the Activity Type <> sequence since it's implied going through the case statement conditions but leaving it in here for clarification WHEN `Activity Type` <> 'sequence' AND `State` = 'finished' THEN 0 -- don't want other activities filtered to Finished ELSE 1 END
**Was this post helpful? Click Agree or Like below**
**Did this solve your problem? Accept it as a solution!**0
Categories
- All Categories
- 1.8K Product Ideas
- 1.8K Ideas Exchange
- 1.5K Connect
- 1.2K Connectors
- 297 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