Beast Mode to Add "Warning" for Data Point

MichaelClark
MichaelClark Wichita Falls, Texas ⚪️

I have the Beast Mode below for a card that reflects IsShortAbandon "Good" when <=.07, else "Bad". I want to add "if .06 - .069 then "Warning". I am struggling a bit with the logic and appreciate in advance any assistance.

Thanks

Michael


Best Answer

  • MarkSnodgrass
    MarkSnodgrass Portland, Oregon 🔵
    Accepted Answer

    Case statements work from the top down and exit out as soon as they find a match, so if you put your statement in a logical order such as evaluating from smallest to largest, you can properly work through the different scenarios.

    In your scenario, I'm guessing you want "Good" to be less than .06, "warning" to be less than .07 and then "bad to be anything else. You can set it up like this....

    CASE WHEN ... <.06 THEN 'Good'

    WHEN ... < .07 THEN 'Warning'

    ELSE 'Bad'

    END

    Also, I would suggest either moving your error logic to the outside or replace 'Error' with 0. Otherwise it is going to try and divide 'Error' by Queued minus 'Error' which won't work.

Answers

  • MichaelClark
    MichaelClark Wichita Falls, Texas ⚪️

    As always, thank you for the guidance Mark!

    Michael

  • MichaelClark
    MichaelClark Wichita Falls, Texas ⚪️

    One question though, will the BeastMode look at <.07 Warning and pick up .05 OR since it is top down, it will stop at .06 line and a .065 would then trigger Warning for .07?

  • MarkSnodgrass
    MarkSnodgrass Portland, Oregon 🔵

    @MichaelClark since it is top down, the .05 will stop at .06 and would not evaluate any lines below it.

    Happy to help!

Sign In or Register to comment.

Hey, Stranger!

It looks like you're new here. Those who sign in get access to engage with even MORE fire content. To get involved, click one of these buttons!