I have a super set and I need to use two filters but as an Or clause.
Comments
-
This is where a "case statement" within a beast mode will solve your problem. For example, create a new beast mode calculation, and you would do something like the following:
CASE
WHEN `region` = 'some value' OR `child region` = 'other value'THEN 1
ELSE 0
END
Then you can add this beast mode as a filter, and filter it for when it equals 1. Or you can add a COUNT() function around the entire case statement, but that should be enough to get your started.
Let me know if you need further help on that.
2 -
Thank you I will try that and see if that works.
1
Categories
- 10.6K All Categories
- APAC User Group
- 12 Welcome
- 36 Domo News
- 9.6K Using Domo
- 1.9K Dataflows
- 2.4K Card Building
- 2.2K Ideas Exchange
- 1.2K Connectors
- 338 Workbench
- 250 Domo Best Practices
- 11 Domo Certification
- 460 Domo Developer
- 47 Domo Everywhere
- 100 Apps
- 703 New to Domo
- 84 Dojo
- Domopalooza
- 1.1K 日本支部
- 4 道場-日本支部へようこそ
- 22 お知らせ
- 62 Kowaza
- 295 仲間に相談
- 649 ひらめき共有