ARutledge Member

thank you for the help everyone!

that worked perfect. thank you so much!!

Thank you so much, Bryce! I do have one more question though, sorry! I only want my card to show newly parked revenue as of this week. I put "snapshot week rank" into the filters and selected 0 but then it got rid of all of the data even though there is newly parked revenue in snapshot week ran 0.

I took another look at the data. Snapshots are taken once a week. (for example the latest snapshots were 4/26, 4/19, 4/12 etc) and then data for current day is also there. Is there a way to screenshare to walk me through this and try and figure it out together?

I added 'Billing Entity' into the partition and it still didn't work. I do have 'Snapshot Week Rank' in my dataset. Where 0 is this week, 1 is last week, 2 is 2 weeks ago etc.

I switched to Megatable and it's still not working.

I don't have any other filters on the card.

I saved the card and refreshed and there are still no yes's to select. I'm not sure what else I need to adjust.

Ahh thank you! I should have caught that too. I was able to create the beast mode now. I did have to add another partition so modified the formula to this: (CASE WHEN LAG('status/stage') OVER (PARTITION BY 'Program Name','Deliverable' ORDER BY Snapshot Date ASC) != 'Parked Revenue' AND 'status/stage' = 'Parked Revenue'…

We do have "Snapshot Date" in the dataset

I entered this formula: (CASE WHEN LAG(Status/Stage) OVER (PARTITION BY Program Name ORDER BY Snapshot Date ASC) != 'Parked Revenue' AND Stage/Status = 'Parked Revenue' THEN 'Yes' ELSE 'No' END) But I get this error: Calculation Error : A column in this calculation did not exist. (screenshot attached)

Okay thank you. Could you help me write a new Beastmode that would work then? I've never used window or fixed function before. I want the card to only show me new programs that have been marked "parked revenue" this week compared to last week when they were not parked.

Thank you so much! It worked great.

Never mind! I think it was because I put the fields after the date field. I was able to make it work when I moved them. Thank you again for all the help!

Thank you so much! That worked perfectly. But now I have another question. I tried to add a couple more rows to my report (sales region and sales client) but I'm getting this error: "An issue has occurred during processing. We are unable to complete the request at this time - 'undefined'" There is no error when I take out…

Hi Mark! Thank you for your reply. I tried this and it didn't seem to work. I used the Beastmode you created above: CASE WHEN DATEDIFF(MAX(Billing Month New),CURRENT_DATE()) < 60 THEN 'Program Ending' ELSE 'All good' END I dragged it into filters and filtered for program ending. I have program names in my rows and I set…