-
% of Revenue Beastmode
I'm trying to create a card that shows revenue % by business unit (example report attached). What beastmode would I use to get the % data I need? I tried this one but it didn't work. Sum(Price USD) / sum(sum(Price USD)) Over ()
-
Beastmode For Prior Month, Current Month, Next Month, Month +2
I currently have 4 different cards that show me the prior month forecast by week, current month forecast by week, next month forecast by week and 2 month ahead forecast by week. All 4 cards show me the current week price forecast, what the price forecast was last week, and the variance between what showed last week and…
-
WoW Comparison BeastMode
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…
-
BeastMode to show an end date that is at least 6 month ago or older
I want to show records where the Program End Date is at least 6 months ago or older — in other words: Include: End Dates before or equal to 6 months ago Exclude: End Dates from 6 months ago up to today Exclude: Future End Dates How can I write this in a Beastmode?
-
Programs Ending in the Next 60 Days
Hello Everyone, I'm trying to create a card that will show what programs we're running will end in the next 60 days. I think a beast mode would help accomplish my goal but I'm unsure of what to do. Each program has multiple billing dates associated with it so I need it to be based off of just the latest billing date.