Splunk Search

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

crisjnelson
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
.conf21 Now Fully Virtual!
Register for FREE Today!

We've made .conf21 totally virtual and totally FREE! Our completely online experience will run from 10/19 through 10/20 with some additional events, too!