11 Replies Latest reply on Nov 30, 2016 8:02 AM by Shinichiro Murakami

    how to get average value of last 3 values only?

    jenn.ng

      i want to get the average of the last 3 values of my time series data. However it sums everything up and did not get the average when i used window_average()

      my data:

      datevalue
      1/1/1610
      2/1/1620
      3/1/1630
      4/1/1640
      5/1/1650

      my function:

      WINDOW_AVG(sum([Value]),-3,0)

       

      The output value i should get is (50+40+30)/3 = 40

      Screen Shot 2016-08-04 at 8.08.57 PM.png