Beast Mode Calculation partly displaying on the card.

learnDomo

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.

marcel_luthi

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.

MichelleH

@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?

learnDomo

Hi MichelleH,

Thanks for reaching out. Here are my beast modes;

IFNULL(CASE WHEN Metric IN ('All Calls','Calls Time') AND Level = 'Stage 1'
THEN SEC_TO_TIME(Total)
ELSE ROUND(SUM(CASE WHEN Level = 'Stage 1' THEN Total END),0)END,0)

IFNULL(CASE WHEN Metric IN ('All Calls','Calls Time') AND Level = 'Stage 2'
THEN SEC_TO_TIME(Total)
ELSE ROUND(SUM(CASE WHEN Level = 'Stage 2' THEN Total END),0)END,0)

IFNULL(CASE WHEN Metric IN ('All Calls','Calls Time') AND Level = 'Stage 3'
THEN SEC_TO_TIME(Total)
ELSE ROUND(SUM(CASE WHEN Level = 'Stage 3' THEN Total END),0)END,0)

ArborRose

Coalesce is easier to apply then IFNULL.

MichelleH

@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 ''.

learnDomo

@MichelleH, have tried changing to a blank but no change.

learnDomo

Its not working.

marcel_luthi

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.