I have a list of average temperature (T_avg) for each of the 365 days.
I want to calculate the "cumulative average" of T_avg of the 30 days prior to the current day.
E.g, the "cumulative avg temperature" for 31-Mar is the average of T_avg from 1 to 30 Mar.
I tried a while with the index() and running_avg() functions, but I didn't get to anywhere.
May I ask your suggestion on how to achieve this?
Have you tried Window_avg([your avg aggregation],-31,-1)?