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.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
- 748 Beast Mode
- 59 App Studio
- 41 Variables
- 686 Automate
- 176 Apps
- 453 APIs & Domo Developer
- 47 Workflows
- 10 DomoAI
- 36 Predict
- 15 Jupyter Workspaces
- 21 R & Python Tiles
- 396 Distribute
- 113 Domo Everywhere
- 276 Scheduled Reports
- 7 Software Integrations
- 125 Manage
- 122 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