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!

Adoption of RUM and APM at Splunk

    Unleash the power of Splunk Observability   Watch Now In this can't miss Tech Talk! The Splunk Growth ...

March Community Office Hours Security Series Uncovered!

Hello Splunk Community! In March, Splunk Community Office Hours spotlighted our fabulous Splunk Threat ...

Stay Connected: Your Guide to April Tech Talks, Office Hours, and Webinars!

Take a look below to explore our upcoming Community Office Hours, Tech Talks, and Webinars in April. This post ...