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

      Hi

       

      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?

       

      Thanks

       

       

      Duncan