Need to calculate WoW% by week number

[Milind]

Hi

I am new to Quicksight & trying to create below view in Pivot table.

1	2	3	4
WoW%	WoW%	WoW%	WoW%

Here, Numbers on first row are week numbers. I tried with few suggestion which I found but somehow not able to get desire output. Note that, I do have few more calculations like CY, PY below WoW calculation, but I am not bother about those for now. Let me know if you have any suggestions. Thanks in Advance.

[prantika_sinha]

Hi @Milind ,

Welcome to the QuickSight Community!

Are you looking to report something similar?

Here to calculate WOW% i have used this formula, you can try this.
periodOverPeriodPercentDifference(sum(Cost), {Date_only}, WEEK,1 )

Please note for window functions to work, your visual must contain the date field used in the calculated field. So if you intend to use week numbers instead of week dates, you may need to customize the visual further.

Thanks,
Prantika

[Milind]

Hi @prantika_sinha
Thank you for you response. I need the similar view as what you have shown above. Only difference that I can make out is, I have taken Week_Number as a column instead of date.
any workaround for this, as what I can understand is I need to take Date field instead of Week_Number in column section of Pivot table to use PeriodOverPeriodPercentDifference().

[sagmukhe]

@Milind - You can try to go through the following links where similar problems have been discussed and resolution was provided. See if those helps! Thank you!

Create Week over Week calculation

Hello, I am trying to calculate Week over Week for the following values. I’m trying to use the “Period over period computation” however I need a ‘date’ for each of my values to do so. In my case, my data is aggregated by week (202236 for WK36 of 2022…) so I don’t have ‘date format’. So I am not able to use the Period over period computation without converting my Weeks in dates (first day of each week for example). Do you know how I could do such thing? Thank you for your support. Sarah

How to create a Week over Week field

@pravaljain and @huangsn, I now get your use cases. In this case, you would want to create a parameter to refer to the week you would like to calculate the WoW and use the function of something like (sumif(measure, week=$parameter)-sumif(measure, week=addDateTime(-1,'WK','$parameter))/sumif(measure, week=addDateTime(-1,'WK','$parameter)). We recently launch another rolling date parameter feature. It may help to make it more dynamic and automatic. Check it out here.

[Milind]

thank you so much @sagmukhe.
I will verify the provided solution and will update the outcome of it.