How to create a Week over Week field

Hello,

I am trying to calculate a Week over Week field, but I can’t do that. Could you, please, help me?

I’m using a pivot table with values (sales, revenue and cost) in rows and weeks in columns. What I want to do is put the week over week values in a column like in this table:

image

Thanks a lot in advance!

Hi there. Have you taken a look at this article: Period Over Period and Other Date Comparison Calculations (YoY, MoM, YTD, Rolling 7 days, etc)?

1 Like

Hi, QuickSight just launched a suite of period-over-period functions. For your case, you just need to add a new calculated fied using this function. It should give you the right answer.
All other period functions are available in these two links: Period over period computation - Amazon QuickSight,
Period to date computation - Amazon QuickSight

2 Likes

FYI, we published this blog post for detailed discussion about use cases and function usage for the period functions.

2 Likes

Thanks Emily,
I actually ran into the same problem.

Follow up question: Is it possible to create exact same table like the excel example^. To be more specific, I want to make Date as the column, Revenue, cost as rows.

I look through all the examples in the articles you mentioned which all of the date is row instead of column.

And only show the one WOW at the end.

1 Like

Hi @huangsn, do you have only two weeks? if you have more weeks how do you expect the result to show?
If you only have two weeks, you don’t need to use period function, you can directly add another calculated field using (sumif(measure, week=2)-sumif(measure, week=1))/sumif(measure, week=1)

1 Like

Hi @emilyzhu!
Thanks for addressing the questions here and helping with the solutions.
I have a similar case as @huangsn but in my case the columns are weeks that dynamically change as we progress through the year. Example: At this moment, my dashboard displays columns in year-MonthNumber format. The columns are 2022-35, 2022-36, 2022-37, 2022-38. Next week, the columns will change to 2022-36, 2022-37, 2022-38, 2022-39.
Since the columns are dynamically changing every week, and I want to calculate the WoW for the two most recent weeks. How do you suggest doing that?

Hi @emilyzhu
Thanks for your help, similar to the WBR, I have 52 weeks data, and only want to display the two most recent weeks.

My use case is exactly same as @pravaljain explained ^.