Join the Conversation
- Find Answers
- :
- Using Splunk
- :
- Splunk Search
- :
- Re: Average of count per second
- Subscribe to RSS Feed
- Mark Topic as New
- Mark Topic as Read
- Float this Topic for Current User
- Bookmark Topic
- Subscribe to Topic
- Mute Topic
- Printer Friendly Page
- Mark as New
- Bookmark Message
- Subscribe to Message
- Mute Message
- Subscribe to RSS Feed
- Permalink
- Report Inappropriate Content
I am trying to get average per second while using this query
Source=
I would like to get the average per second using this formula
(latest-earliest)= 2 minute = 120 seconds
Then if my Count for logRecordType="V" is 240 then it should be 2 = 240/120
And if my count for logRecordType="U" is 360 then it should be 3 = 360/120
- Mark as New
- Bookmark Message
- Subscribe to Message
- Mute Message
- Subscribe to RSS Feed
- Permalink
- Report Inappropriate Content
try this
source=abc (logRecordType="V" OR logRecordType="U") earliest=2/25/2014:22:00:00 latest=2/25/2014:22:02:00 | addinfo | eval totalSecs=info_max_time - info_min_time | stats count by logRecordType, totalSecs | eval Avg=round(count/totalSecs,2) | table logRecordType, Avg
- Mark as New
- Bookmark Message
- Subscribe to Message
- Mute Message
- Subscribe to RSS Feed
- Permalink
- Report Inappropriate Content
Welcome to the forum vinraisf. If an answer to your question solves your problem, please mark the question as answered by ticking the check mark next to the correct answer. (like I did for you here)
You can also vote answers up or down if they were particularly helpful.
Happy Splunking,
K
- Mark as New
- Bookmark Message
- Subscribe to Message
- Mute Message
- Subscribe to RSS Feed
- Permalink
- Report Inappropriate Content
That worked like a charm, thank you so much someson12! I really appreciate it.
- Mark as New
- Bookmark Message
- Subscribe to Message
- Mute Message
- Subscribe to RSS Feed
- Permalink
- Report Inappropriate Content
try this
source=abc (logRecordType="V" OR logRecordType="U") earliest=2/25/2014:22:00:00 latest=2/25/2014:22:02:00 | addinfo | eval totalSecs=info_max_time - info_min_time | stats count by logRecordType, totalSecs | eval Avg=round(count/totalSecs,2) | table logRecordType, Avg
Join the Splunk Community Slack to learn, troubleshoot, and make connections with fellow Splunk practitioners in real time!
Join Splunk User Groups to connect and learn in-person by region or remotely by topic or industry.
Announcing Modern Navigation: A New Era of Splunk User Experience
Modernize your Splunk Apps – Introducing Python 3.13 in Splunk
Step into “Hunt the Insider: An Splunk ES Premier Mystery” to catch a cybercriminal ...
