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?