Hello,
I have a set of monthly measurement values dating back from 2014 to now.
I would like to have a plot with, next to the monthly values, a moving average over a year.
I use the following formula:
rangeavg(above(avg(value),0,12))
This formula works fine from 2015 onwards, since at that time I have 12 data points prior so a yearly moving average makes sense. For 2014 of course, this is not the case.
Is there a way to only start plotting from 2015 onwards, while simultaneously taking into account the 2014 data?
If I try this via a set analysis ( year = {">=2015"} ) the values for 2015 are wrong...