Alert Bases on Average for Day of Week
For a daily alert, we can not merely measure the difference between two consecutive days because day of week matters - we have much lower traffic on the weekends, a Monday peak followed by a typical slow decline.
What I would like to do for an alert is something like this:
For the particular day of week, if variance of the count of records is more than +/- 20%, as compared to the AVERAGE COUNT count of records for the same day of week over the last 60 days, then alarm.
I have messed with beast modes, and don't want to do a data flow if i don't have to. Any suggestions? Thanks.