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
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'
- 10.7K All Categories
- 13 Getting Started in the Community
- 37 Beastmode & Analytics
- 2.1K Data Platform & Data Science
- 59 Domo Everywhere
- 2.7K Charting
- 2.5K Ideas Exchange
- 1.3K Connectors
- 362 Workbench
- 303 Use Cases & Best Practices
- 500 APIs
- 118 Apps
- 48 News
- 753 Onboarding
- 1.2K 日本支部
- Private Company Board