1 Reply Latest reply: Jun 2, 2015 10:31 PM by Johannes Sunden RSS

    Average of Data occurring on same date each year

      I have a set of data spanning a number of years.  I want to chart the average of the value for the same day for the past x years.

       

      ie.

       

      DayValue
      1 Jan 20135
      2 Jan 20136
      3 Jan 20137
      1 Jan 20141
      2 Jan 20142
      3 Jan 20143
      1 Jan 20154
      2 Jan 20155
      3 Jan 20156

       

      So I want to be able to plot 2015 data which is easy to extract, but then I want to be able to plot the average for that day from the past 2 years alongside. i.e. the result set becomes

      Header 12015Average Last 2 Years
      1 January43=(5+1)/2
      2 January54=(6+2)/2
      3 January65=(7+3)/2

      What I'm trying to do is similar to how they report what the average temperature on this day has been over the last 10 years or so, the average is not the last 10 days, its the average for that same day of the year for the past 10 years.

       

      Can someone assist with how to do an appropriate average or range function to get the required results.  Your assistance is much appreciated.

      Jamie