6 Replies Latest reply on Sep 9, 2017 6:43 AM by Taku Shikanai

    Question about moving average.

    Taku Shikanai

      I calculate the 7-day moving average of the number of airline passenger.

       

      I want to get a 7-day moving average up to the last ticketed date (September 3)

       

      Calculations included even after September 4th of 0 people who attracted customers are automatically done, the line graph will go down to the bottom.

      (Please refer to the figure at the bottom of the dashboard.)

       

      The expression you are using is "WINDOW_ AVG (SUM ([Pax(null)]), -6, 0)".

       

      Please teach me.