Beast Mode Calculation partly displaying on the card.
Hello, I need some help.
I have made some calculations in beast mode to convert minutes to seconds & the beast mode runs ok. However when I pull in the metrics & respective stages into the card, only the first stage returns the expected values. The formula for all the stages is the same but only changing the stage level.
| Metric | Stage 1 | Stage 2 | Stage 3 | Stage 4 |
---|---|---|---|---|---|
xxxxx | All Calls | 0:10:35 | 5410 | 1948.5 | 2498 |
| Call Time | 0:25:19 | 1823 | 599.02 | 4458.13 |
What could be the problem with my card.
Best Answer
-
I just noticed that for the first case you're using SEC_TO_TIME but on all of the others you are not, this is likely why it's not being displayed the right way as that conversion is not happening, try adding that as a wrapper to your ROUND functions.
0
Answers
-
@learnDomo Can you please share all your beast modes for the various stages? Also, do you have formatting applied to any of the columns in your table?
0 -
Hi MichelleH,
Thanks for reaching out. Here are my beast modes;
IFNULL(CASE WHEN
Metric
IN ('All Calls','Calls Time') ANDLevel
= 'Stage 1'
THEN SEC_TO_TIME(Total
)
ELSE ROUND(SUM(CASE WHENLevel
= 'Stage 1' THENTotal
END),0)END,0)IFNULL(CASE WHEN
Metric
IN ('All Calls','Calls Time') ANDLevel
= 'Stage 2'
THEN SEC_TO_TIME(Total
)
ELSE ROUND(SUM(CASE WHENLevel
= 'Stage 2' THENTotal
END),0)END,0)IFNULL(CASE WHEN
Metric
IN ('All Calls','Calls Time') ANDLevel
= 'Stage 3'
THEN SEC_TO_TIME(Total
)
ELSE ROUND(SUM(CASE WHENLevel
= 'Stage 3' THENTotal
END),0)END,0)0 -
Coalesce is easier to apply then IFNULL.
** Was this post helpful? Click Agree or Like below. **
** Did this solve your problem? Accept it as a solution! **0 -
@learnDomo By forcing null values to 0, the stages with nulls are likely being converted to an integer. Try changing the 0 to a blank string
''
.0 -
@MichelleH, have tried changing to a blank but no change.
0 -
Its not working.
0 -
I just noticed that for the first case you're using SEC_TO_TIME but on all of the others you are not, this is likely why it's not being displayed the right way as that conversion is not happening, try adding that as a wrapper to your ROUND functions.
0
Categories
- All Categories
- 1.7K Product Ideas
- 1.7K Ideas Exchange
- 1.5K Connect
- 1.2K Connectors
- 294 Workbench
- 6 Cloud Amplifier
- 8 Federated
- 2.8K Transform
- 97 SQL DataFlows
- 607 Datasets
- 2.1K Magic ETL
- 3.8K Visualize
- 2.4K Charting
- 707 Beast Mode
- 49 App Studio
- 39 Variables
- 667 Automate
- 170 Apps
- 446 APIs & Domo Developer
- 44 Workflows
- 7 DomoAI
- 33 Predict
- 13 Jupyter Workspaces
- 20 R & Python Tiles
- 391 Distribute
- 111 Domo Everywhere
- 274 Scheduled Reports
- 6 Software Integrations
- 115 Manage
- 112 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