WoW Comparison BeastMode

ARutledge
ARutledge Member
in Beast Mode

I'm trying to make a card that will show me revenue that has been newly parked (week over week). Our data captures snapshots each week of the data so we can compare if there are changes week to week. This is the BeastMode we thought would work but it's not working properly:

Case WHEN (Snapshot Week Rank = 1 and Status/Stage != 'Parked Revenue') and (Snapshot Week Rank = 0 and Status/Stage = 'Parked Revenue') then 'Newly Parked' END

Are there any suggestions how to make this function properly or another Beastmode that would work better?

Answers

  • brycec
    brycec Coach

    In your Beast Mode, your condition has Snapshot Week Rank = 1 AND Snapshot Week Rank = 0, which cannot both be true at the same. The same is happening to the Status/Stage condition. For week over week, you can use a Period Over Period chart type, change the graph by period to week, and compare week over week. Alternatively, if you are trying to do it in a Beast Mode, you can use a Window or Fixed function.

    Was this comment helpful? Click Agree or Like below.
    Did this comment solve your problem? Accept it as the solution!

Categories