Last 52 weeks Calculation

lokeshm

I have a requirement to show the last 52 weeks value. I want to create another line item which has to sum last 52 weeks total hours

e.g.: 03/08/2025 should show the last 52 weeks data

this should be dynamic and 52 weeks should change based on the week.

Thanks in Advance.

AjayM

HI @Lokesh_Madhu ,

If you were using native time dimension, movingsum function could have been of help.
But from the snapshot, it appears like a custom time dimension. In this case, you may have to introduce a replica list of custom time dimension, using which you could identify last 52 weeks for each week item, and then use the combination of these two dimensions to fetch the data and aggregate as needed.

Cheers!