Pivot Table Week over Week % Change

ccc123

I want to show the WoW % change for my data but not really sure how to go about it. My raw data is daily and I grouped it into weeks in the pivot table. I want to add a column to my table where it will show the % change of sales from the previous week.

trafalger

You'll have to do this in the dataflow!

@GrantSmith and @DashboardDude gave great answers for this problem here! You'll just have to use week instead of month.

https://community-forums.domo.com/main/discussion/56964/month-over-month-comparison-on-mega-table-pivot-table

trafalger

You'll have to do this in the dataflow!

@GrantSmith and @DashboardDude gave great answers for this problem here! You'll just have to use week instead of month.

https://community-forums.domo.com/main/discussion/56964/month-over-month-comparison-on-mega-table-pivot-table

DashboardDude

Thanks @trafalger for the shoutout. @ccc123 let me know if you have questions too!

ccc123

https://community-forums.domo.com/main/discussion/comment/69998#Comment_69998

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 sales end)/ sum(case when day(date_)-day(CURDATE()) and week(date_)-week(CURDATE()) then spend end)
/
sum(case when day(date_)-day(CURDATE() - INTERVAL 7 day) and week(date_)-week(CURDATE() - INTERVAL 7 day) then sales end)/ sum(case when day(date_)-day(CURDATE() - INTERVAL 7 day) and week(date_)-week(CURDATE() - INTERVAL 7 day) then spend end)) - 1