WoW Comparison BeastMode

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.

(CASE

  WHEN LAG(`Status/Stage`) OVER (PARTITION BY `<unique_identifier>` ORDER BY `Snapshot Date` ASC) != 'Parked Revenue' 
    AND `Stage/Status` = 'Parked Revenue' THEN 'Yes'
  ELSE 'No'
END)

Add this Beast Mode as a filter, and select Yes. Make sure to replace the unique_identifier field with whatever your unique identifier is in the DataSet. Then, have the y-axis value of the chart be a count of your unique identifier column.

What is the date column for when your snapshot occurred called? I just put Snapshot Date as an assumption, but yours isn't called that probably.

Oh lol, I put Status/Stage then Stage/Status. Just adjust the second reference to be Status/Stage.

There should be yes's to select. Sometimes with window functions you have to save the card so that the Beast Mode saves, then refresh and see if you can select them then. If they still aren't there, something else needs to be adjusted.

What is your date range filtered to? Or do you have any other filters on the card that could be filtering the values you need out?

Oh, you're using a pivot table? That might be the issue. They aggregate things a lot differently and I haven't verified this specific Beast Mode on one. Can you try using a mega table?

You would have to add Billing Entity to the partition if you want to have that in the table too. But, if that doesn't work, then maybe another solution is best. You could make a column in the DataFlow to use. And maybe you already have that and I missed it. What is the Snapshot Week Rank column?

In your initial post, you said the data was snapshotted every week. But in a recent reply, you said the data was snapshotted every day. Which is it? I've been under the assumption that it was once a week, so if that isn't true, the Beast Mode would need to be updated to reflect that. There is likely a way to achieve it in the Beast Mode, but if it is every day it is probably just easier to achieve it in the DataFlow.

What you want is to have the Status/Stage from last week be on the same row as the Status/Stage from this week. That is what I was trying to have you achieve with the window function in the Beast Mode. In the DataFlow, the best way to do that is the Rank & Window tile, but in this case it could also be achieved with a join. For Rank & Window, you'd set it up the same as the Beast Mode. But first, you need to group the data by week. You can choose to join this afterward to the original data if you still want it to be by day. Then use the Lag function on the Status/Stage column and name it something like Previous Week Status/Stage, sort by Snapshot Date or Snapshot Week Rank and partition by your other columns. Then, in a Beast Mode in the card, you just need to compare where Previous Week Status/Stage != 'Parked Revenue' and Stage/Status = 'Parked Revenue' and filter to that.

Sure, I'll DM you