Comments
-
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…