@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!
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
@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 .