6 Replies Latest reply on Oct 24, 2017 12:13 PM by Shinichiro Murakami

    3-Year Running Average (by Day) vs. Current Average (by day)

    Tanner Mcconvey

      Hello,

       

      I am trying to make a view to show a line graph, with the dates on the X-Axis (past 7 days, i.e. I've I am looking at the dash today(10/24/2017) I would like to see 10/17/2017 to 10/23/2017). On the Y-Axis I would like to see both a current year average by day line, as well as, a line showing the same dates but the average from the last 3 years(only 2015 and 2016) by day.

       

      The data basically is on-time performance by date for an airline. to get the average D0 performance I do: ((sum of D0)/100)/count of flights). Below is a quick example of what the data would look like.

       

      DateD0 Performance

      1/1/2017

      100
      1/1/20170
      1/1/2017100
      1/1/20170
      1/2/2017100
      1/2/2017100
      1/3/2017100
      1/3/2017100
      1/3/2017100
      1/3/20170