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
Get Updates on the Splunk Community!

Registration for Splunk University is Now Open!

Are you ready for an adventure in learning?   Brace yourselves because Splunk University is back, and it's ...

Splunkbase | Splunk Dashboard Examples App for SimpleXML End of Life

The Splunk Dashboard Examples App for SimpleXML will reach end of support on Dec 19, 2024, after which no new ...

Understanding Generative AI Techniques and Their Application in Cybersecurity

Watch On-Demand Artificial intelligence is the talk of the town nowadays, with industries of all kinds ...