1 Reply Latest reply on Jan 14, 2012 11:09 AM by Joe Mako

    Compare day of week data to the window average for that day

    Duncan Ritchie



      I would like to compare ticket volumes to the average for the same day of the week.  At the moment I have been using this formula to calculate the difference from the average SUM([Number of Records])-WINDOW_AVG(SUM([Number of Records]),FIRST(), LAST()) however it compares to the daily average for the whole period.


      What I want to end up with is Monday compared to the average Monday volume, Tuesday to Tuesday etc.


      I have attached the current output using the formula above.


      Any suggestions on how this can be done?