Rolling 12 month sum

Hi Janus,

If I understand correctly all you need is a dynamic time filter like this:

Using the "Editor" is necessary, because the default filters do not cover the whole last year like you need:

Click on "between" to define a time range where the from-date is minus 1 year plus 1 day:

Define the to-date and click OK:

 

Then you can create a line chart like this:

If you have further questions feel free to ask.

BR

Marlene

Hi Marlene,

As I can see it will only show the dates 12 month back but not the sum of Last 12 month with offset in each date.

I want the total sum of a 12 month period per date over time. It needs to accumulate the values.

Hope it makes sense?

 

 

There is a smart calculation for accumulating.

If this is not what you mean, I would need an example in e.g. Excel.

BR, Marlene

Hi Marlene,

I need the accumulated sum for each showen date. It means that in your example I will need the accumulated sum for november 2022 as well.

For each point on the graph it should be LTM back. Below you will see an example created in Excel as requested:

 

The formula is sum(0, -11:0, m1) to get the sum of all 12 previous months.

Hi Marlene,

But as I understand it is a static range?

Not all dates are represented in my data so doing a sum over a static range will not work.

As described: if I have the date 8th of november 2023 I need the sum of all values between the 8th of november 2022 and 7th of november 2023. This for each date back in time.