7 Replies Latest reply on Sep 3, 2018 7:43 AM by Joe Smith

    how to get the averge of a given number of values prior to the current one?

    Joe Smith

      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?

       

      Thanks.