Beast Mode Calculation partly displaying on the card.

learnDomo
learnDomo Member
in Magic ETL

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

  • marcel_luthi
    marcel_luthi Coach
    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.

Answers

  • MichelleH
    MichelleH Coach

    @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
    learnDomo Member

    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
    ArborRose Coach

    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! **

  • MichelleH
    MichelleH Coach

    @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
    learnDomo Member

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

  • learnDomo
    learnDomo Member

    Its not working.

  • marcel_luthi
    marcel_luthi Coach
    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.

Categories