YoY WoW Calculation

Question & Answer
,
1

I am currently working on a calculation that takes the YoY %, then takes the WoW in BPS. I am able to get the YoY % using a periodoverperiodpercent calculated field but can’t use it in nested function to get the WoW. What is the best way to go about this?

2

@Matthew_Payne, can you clarify your comment about nesting function to get the WoW. Periodoverperiodpercent functions have period argument that can take values such as YEAR, QUARTER, MONTH, WEEK, DAY, HOUR, MINUTE, and SECONDS, so you can create a calculated column for year and another one for week.

3

So I have this calculation to get the YoY%, periodOverPeriodPercentDifference(sum({gms_retail}),{grouping_period_day},DAY,364)

I then need to get the WoW for the calculation above, in BPS, but the calculation below gives me a nesting error.
periodOverPeriodPercentDifference(sum({gms_retail}),{grouping_period_day},DAY,7)

4

@Matthew_Payne I have created two periodoverperiodpercentdifference calculations, one for week and one for year as below and able to view both in table. So I am not following the ask of nesting functions to get week values.
WK - periodOverPeriodPercentDifference(sum(Sales),{Order Date},DAY,7)
YR - periodOverPeriodPercentDifference(sum(Sales),{Order Date},DAY,365)

image

5

I was able to figure it out, First Year over Year to get the YoY %
YR - periodOverPeriodPercentDifference(sum(Sales),{Order Date},DAY,365)
, then
WoW periodOverPeriodPercentDifference(Sales,{Order Date},DAY,7)
to get the YoY WoW calculation. I had a SUM before the Sales in WoW calculation which needed to removed.