9 Replies Latest reply on May 1, 2017 1:32 PM by Joe Oppelt

    Average for same weekday past 4 weeks?

    Maximus Decimus Meridius

      I want to compare the value of any given day - say a Sunday - and compare it to the average value of the 4 past Sundays (or whatever day).

       

      What I'm hoping is to flatten out these trend lines (which show totals), so I can more clearly see when something deviates from the average value for that weekday:

       

      So here when there's a dip, I want to understand if it's an unusual dip for that weekday or if it's to be expected. I essentially want to remove the day of week effect from this data - the past 4 weeks of data form the same weekday is the first approach I thought of (and I figure it might be the easiest) but I'm interested in hearing other solutions as well.