Need to calculate WoW% by week number

[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.