WoW Comparison BeastMode

ARutledge

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?

brycec

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.