Splunk Search

How can a row of average hourly event volume be appended to a chart with Fridays' hourly totals and added totals?

Explorer

Here is my attempt at creating a chart of hourly counts for previous Fridays. I have added row and column totals, but can't quite figure out how to add hourly averages per day.

index=everything earliest=-2week@week date_wday="friday"
| eval date = strftime(_time, "%Y-%m-%d")
| eval date_hour = strftime(_time, "%H")
| chart count by date_hour date useother=f usenull=f
| addtotals col=t labelfield=date_hour label="Total"
| appendpipe [ | stats avg(count) as date by date_hour
| eval date_hour = "Average" ]

Thanks.

0 Karma