Splunk Search

Can I use the same search but divide the results of one time frame with another?

mcram52
New Member

How can I use the same search to divide the results of a specific time frame with the total daily sum to get a percentage? My base query would be this:

(index=epackage OR index=dxprd01-epackage) flow_event=Package* 
    | stats sum(numberOfReports)

So basically I'm interested in getting the sum(numberOfReports) from 9-11am, then the sum(numberOfReports) total for the day, then divide the two and multiply by 100 (unless there's an easier way to get the percentage). I have no idea where to even start with this (or if it's even possible) so any help would be fantastic.

Tags (1)
0 Karma

jpolvino
Builder

You could "mark" events in your time window:

...
| eval criticalEvent=if(date_hour>=9 and date_hour<11,1,null())
| stats sum(criticalEvent) AS criticalCount count AS totalVolume
| eval percentage=criticalCount/totalVolume*100
0 Karma
Get Updates on the Splunk Community!

.conf24 | Registration Open!

Hello, hello! I come bearing good news: Registration for .conf24 is now open!   conf is Splunk’s rad annual ...

Using the Splunk Threat Research Team’s Latest Security Content

REGISTER HERE Tech Talk | Security Edition Did you know the Splunk Threat Research Team regularly releases ...

SplunkTrust | 2024 SplunkTrust Application Period is Open!

It's that time again, folks! That's right, the application/nomination period for the 2024 SplunkTrust is ...