Rolling 12 month sum
Hi,
How can I make a Rolling 12 month sum and visualize it in a line chart.
For instance:
if I look at the value in the chart at the 5th of October 2023 It should be the sum of all values between the 6th of October 2022 and the 5th of October 2023.
If I look at the value at the 7th of April 2023 it should be the sum of all values between the 8th of April 2022 and the 7th of April 2023.
Note:
1. Not all dates are represented in the dataset
2. It has to be represented in a line chart so I can see the development of the Rolling 12 month sum.
0
Comments
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.
Please sign in to leave a comment.