1 Reply Latest reply on Jun 13, 2018 1:02 AM by Zhouyi Zhang

    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.