Case statement clarification
This seems pretty straightfoward, but I wasn't able to find a definitive answer searching Domo or Google. We're hoping to clarify whether the beast mode formula (case statement using "OR") will return a total count of five (5), i.e. count each row one time or eleven (11), i.e. instead counting EACH instance of a condition being met individually. An example of the beast mode & data being used is below.
Thanks in advance for any clarification provided...
WHEN (`Record.Name` LIKE '%Team1%'
OR `Owner.Title` LIKE '%Team1%'
OR `Owner.Name` = 'Loss Prevention - Direct'
OR `Owner.Name` = 'Loss Prevention - Indirect'
OR `Owner.Name` = 'Claim Follow-up - Direct'
OR `Owner.Name` = 'Claim Follow-up - Indirect'
OR `Owner.Name` LIKE '%Team1%') THEN 1
In your example a count on the beastmode would return 5. Once a value is found in a multiple OR statement like that, it immediately dumps out to the THEN and ENDS. It wouldn't get caught multiple times in the same count.
Hope that clarifies. If not, please let me know.
**Please mark "Accept as Solution" if this post solves your problem
**Say "Thanks" by clicking the "heart" in the post that helped you.3
I haven't been able to use OR statements succesfully in beast mode but I don't think it will count it separately because, from my understanding of how the case statement works, as soon as it gets to the first condition that is true, it will stop going through the rest of the statement. For example, if a record meets the `Record.Name` LIKE '%Team1%' condition, it will jump to the Then statement and stop. It will not continue to go through the rest of the case statement.
Also, i don't think the case statement as you have it will work in a beast mode. I think you'll have to change it to something like:
WHEN `Record.Name` LIKE '%Team1%' THEN 1
WHEN `Owner.Title` LIKE '%Team1%'THEN 1
WHEN `Owner.Name` = 'Loss Prevention - Direct' THEN 1
WHEN `Owner.Name` = 'Loss Prevention - Indirect' THEN 1
WHEN `Owner.Name` = 'Claim Follow-up - Direct' THEN 1
WHEN `Owner.Name` = 'Claim Follow-up - Indirect' THEN 1
WHEN `Owner.Name` LIKE '%Team1%' THEN 1
**Say 'Thanks' by clicking the thumbs up in the post that helped you.
**Please mark the post that solves your problem as 'Accepted Solution'2
@John-Peddle That's correct1
Thank you both for your assistance! Thought I'd read something previously that stated what your replies indicated but for the life of me couldn't locate that information anywhere in a search, and just wanted to be certain. Have a great day!2
- 7.6K All Categories
- 913 Connectors
- 241 Workbench
- 470 Transform
- 1.8K Magic ETL
- 60 SQL DataFlows
- 445 Datasets
- 23 Visualize
- 194 Beast Mode
- 2K Charting
- 6 Variables
- 14 Cards, Dashboards, Stories
- 1 Automate
- 348 APIs & Domo Developer
- 82 Apps
- 14 Predict
- 3 Jupyter Workspaces
- 11 R & Python Tiles
- 241 Distribute
- 59 Domo Everywhere
- 241 Scheduled Reports
- 14 Manage
- 35 Governance & Security
- 17 Product Ideas
- 1.1K Ideas Exchange
- Community Forums
- 15 Getting Started
- 1 Community Member Introductions
- 49 Community News
- 18 Event Recordings
- 579 日本支部