Question related to case when formula in beast mode
Hi,
I would like to ask about the beast mode formula related to this situation. I would like to get the data like this:
- If rating 'Superb' and 'Outstanding' are below 10 % then it's 'Below'
- If rating 'Superb' and 'Outstanding' are above 35% then it's 'Over'
- However, 'Superb' shouldn't be more than 5%
What is the suitable formula in beast mode to answer the case above?
Thank you!
Answers
-
Hi @ndldty, I would recommend splitting your `rating' field in the data set. Instead of relying more on the beast mode calculations, for example through a nested beast mode, you can utilise Magic ETL to make it easy to call those different ratings to then code your beast modes (whether for this case or for future ones). Have a read of this to split your data column: https://domohelp.domo.com/hc/en-us/articles/360044951294-New-Magic-ETL-Tiles-Pivot.
7 -
Hi @ndldty
You can do something like this with a case statement (assuming superb and outstanding are separate value columns):
CASE WHEN `Superb` < 0.10 AND `Outstanding` < 0.10 THEN 'Below' WHEN `Superb` > 0.35 AND `Outstanding > 0.35 THEN 'Above' ELSE 'OTHER' END
As for the Superb can't be more than 5% that doesn't really fit with your other logic - Meaning it can never be above. Can you clarify the Superb can't be more than 5% statement?
**Was this post helpful? Click Agree or Like below**
**Did this solve your problem? Accept it as a solution!**1
Categories
- All Categories
- 1.8K Product Ideas
- 1.8K Ideas Exchange
- 1.6K Connect
- 1.2K Connectors
- 300 Workbench
- 6 Cloud Amplifier
- 9 Federated
- 2.9K Transform
- 101 SQL DataFlows
- 622 Datasets
- 2.2K Magic ETL
- 3.9K Visualize
- 2.5K Charting
- 747 Beast Mode
- 60 App Studio
- 41 Variables
- 687 Automate
- 177 Apps
- 453 APIs & Domo Developer
- 47 Workflows
- 10 DomoAI
- 36 Predict
- 15 Jupyter Workspaces
- 21 R & Python Tiles
- 397 Distribute
- 114 Domo Everywhere
- 276 Scheduled Reports
- 7 Software Integrations
- 126 Manage
- 123 Governance & Security
- 8 Domo Community Gallery
- 38 Product Releases
- 10 Domo University
- 5.4K Community Forums
- 40 Getting Started
- 30 Community Member Introductions
- 109 Community Announcements
- 4.8K Archive