I am trying to get an average for the last (x) days for a that specific day and hour.
This search lists a count for the current day. I am trying to achieve an average for a specific field for the last 5 Mondays or Tuesdays or Wednesday..etc. So if today was Monday, the first value, AL-A at 00, would be the average of the past (x) Mondays at 00 for AL-A.
index=net_auth_long | eval time_hour=strftime(_time,"%H") | chart count over channel by time_hour limit=30