Splunk Search

aggregate hourly events

elaine0102
Explorer

Hi, how can I get aggregate hourly events. The search command using "avg"?
Guide please. Thankyou.

Tags (1)
0 Karma

Ayn
Legend

So, let's say you have events that represent tweets (one event per tweet) and you want to get a average of some time period on how many tweets are made daily.

First of all get a count per day, then use the numbers you just got to get your average.

(some search that finds your tweet events) | timechart span=1d count | stats avg(count)
0 Karma

elaine0102
Explorer

Yes, I would need some numbers to create some charts for my events. My application is actually displaying my company's Twitter information. I thought of displaying on average, how many tweets my company tweets daily.

Mathematics term I know is to add all the tweets daily and divide by number of days.

However, in Splunk's language, I do not know how. I look at Splunk documentation for search language however I do not understand the part where they used "avg".

0 Karma

Ayn
Legend

The information you provide isn't sufficient to give any meaningful answer. How do you mean what your events are, "on average"? Do you want some kind of number, and if so, which?

0 Karma

elaine0102
Explorer

I actually want to know on average what is my daily/hourly/monthly events. Can you guide me on either 1. Thank you.

By chance if you have any idea about this thread: http://splunk-base.splunk.com/answers/65303/issue-regarding-date_wday

0 Karma

Ayn
Legend

Provide more details on your scenario please. Thankyou.

0 Karma
Get Updates on the Splunk Community!

Routing logs with Splunk OTel Collector for Kubernetes

The Splunk Distribution of the OpenTelemetry (OTel) Collector is a product that provides a way to ingest ...

Welcome to the Splunk Community!

(view in My Videos) We're so glad you're here! The Splunk Community is place to connect, learn, give back, and ...

Tech Talk | Elevating Digital Service Excellence: The Synergy of Splunk RUM & APM

Elevating Digital Service Excellence: The Synergy of Real User Monitoring and Application Performance ...