Can we create a beast mode calculation with case statement for a value field?
Answers
-
Hi @Salmas, what's the scenario/question you are trying to solve for here?
If you want to know the number of instances where values fall in the '0-1' range for example, what you can do is have a table chart with two columns:
1) 'Beast mode' where you have define your range conditions
2) Count of 'Beast mode', where you click on the 2nd column field and change the 'Aggregation' to 'Count'
7 -
Its a bit difficult to help diagnose your issue without understanding what the current counts are and what you’re expecting them to be. Do you have any sample anonymized data you can post to help paint a better picture of your issue?
**Was this post helpful? Click Agree or Like below**
**Did this solve your problem? Accept it as a solution!**0 -
what you CAN do is write
case when value = 1 then 'between 0 and 1 when value = 2 then between 1 and 2 ... end
this will work fine because the CASE statement is evaluated BEFORE aggregation.
what you CANNOT do is write:
case when sum(amount) between 0 and 1 then ...
because the case statement is evaluated AFTER aggregatioin. after aggregation, you already have a set number of rows. you could not add the resulting beast mode to your group by clause because that would require analyzer to run two subqueries (recalculate your results) twice.
Jae Wilson
Check out my 🎥 Domo Training YouTube Channel 👨💻
**Say "Thanks" by clicking the ❤️ in the post that helped you.
**Please mark the post that solves your problem by clicking on "Accept as Solution"0
Categories
- All Categories
- 1.7K Product Ideas
- 1.7K Ideas Exchange
- 1.5K Connect
- 1.2K Connectors
- 295 Workbench
- 6 Cloud Amplifier
- 8 Federated
- 2.8K Transform
- 97 SQL DataFlows
- 608 Datasets
- 2.1K Magic ETL
- 3.8K Visualize
- 2.4K Charting
- 710 Beast Mode
- 50 App Studio
- 39 Variables
- 668 Automate
- 170 Apps
- 446 APIs & Domo Developer
- 45 Workflows
- 7 DomoAI
- 33 Predict
- 13 Jupyter Workspaces
- 20 R & Python Tiles
- 391 Distribute
- 111 Domo Everywhere
- 274 Scheduled Reports
- 6 Software Integrations
- 116 Manage
- 113 Governance & Security
- Domo Community Gallery
- 31 Product Releases
- 9 Domo University
- 5.3K Community Forums
- 40 Getting Started
- 30 Community Member Introductions
- 103 Community Announcements
- 4.8K Archive