Last 52 weeks Calculation

Lokesh_Madhu
Lokesh_Madhu
in Modeling

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.

image.png

Thanks in Advance.

Tagged:

Best Answer

  • AjayM
    AjayM
    Answer ✓

    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!

Answers

  • devrathahuja
    devrathahuja

    Hi @lokeshmadhu4 ,
    If your source data is still at native time.

    You can create a mapping for this custom list to native time. Calculate the 52 weeks prior to that & convert it back to the custom list mapping.

    You can then use timesum over the start & end native time mapping against your custom time list to sum up the data.

    Hope this helps!

Categories