ccc123

@marcel_luthi the first part below calculates the last week ROAS and its always calculated from the raw dataset, which is why it almost looks the same except for the 'Spend' and 'Sales'. This part is working correctly and it returns last week's ROAS. (sum(case when day(date_)-day(CURDATE()) and week(date_)-week(CURDATE())…

in Is it possible to calculate ROAS and WoW change in the same beast mode formula? Comment by ccc123 July 2023

Hey I appreciate your video, I'm still having issues with my formula though. Im trying to calculate WoW % change between current ROAS vs. previous week ROAS. This is the formula that I'm using, I used the formula in your video as a reference: (sum(case when day(date_)-day(CURDATE()) and week(date_)-week(CURDATE()) then…

in Pivot Table Week over Week % Change Comment by ccc123 July 2023

I'm using the dashboard filters

in Issues with filtering different datasets Comment by ccc123 July 2023

ccc123 Member

Comments