Unlock a world of possibilities! Login now and discover the exclusive benefits awaiting you.
Hi,
I have period values for order intake, which I show as bars.
Additionally I would like to have a LTM (Last Twelve Months aka Rolling12) line in the diagram.
My problem is, if I have equal or less than 12 periods, it is more a YTD value, like he is simply adding up
the shown period values.
For example: Here he adds up the monthly values... I would like to let the line start already over the first value
with the last not visible 11 values + the period value visible.
If I have even less values, he simply adds them up, there is no Rolling 12:
I have tried the following formulas:
rangesum(above(sum(AE/1000),0,12))
and
accumulation 12 steps back:
As a LKM line/cuve is quite common, I hope someone has a solution??
Or do I somehow have to build a new value in the script somehow??
Thanks!