Splunk Search

Calculate percent

C37996518
Explorer

index=Myindex sourcetype=mine mysearch    | eval Result=if(Apple="1","Bad","Good")
| stats count by Result

 

The search above gives me the correct count of events where Apple="1"

eg

Result                                                 Count

Bad                                                       5 

Good                                                  12392

 

How do I express the stats as a  single value in percentage ie  Bad/Good?

How do I alert  if the percentage  > .02%

Labels (1)
0 Karma
1 Solution

bowesmana
SplunkTrust
SplunkTrust

NB: and on a slight technical note to ITWhispers comments, if you're looking for bad as a % of total rather than of goodNB, then

 

| eval percent=100*Bad/(Bad+Good)

 

View solution in original post

C37996518
Explorer

@C37996518 wrote:

index=Myindex sourcetype=mine mysearch    | eval Result=if(Apple="1","Bad","Good")
| stats count by Result

 

The search above gives me the correct count of events where Apple="1"

eg

Result                                                 Count

Bad                                                       5 

Good                                                  12392

 

How do I express the stats as a  single value in percentage ie  Bad/Good?

How do I alert  if the percentage  > .02%


Thanks to both. Perfect!!

0 Karma

bowesmana
SplunkTrust
SplunkTrust

NB: and on a slight technical note to ITWhispers comments, if you're looking for bad as a % of total rather than of goodNB, then

 

| eval percent=100*Bad/(Bad+Good)

 

ITWhisperer
SplunkTrust
SplunkTrust
index=Myindex sourcetype=mine mysearch
| eval Bad=if(Apple="1",1,0)
| eval Good=if(Apple="1",0,1)
| stats sum(Bad) as Bad sum(Good) as Good
| eval percent=100*Bad/Good
| where percent>0.02

The last line is for the alert so that you only get results when the percentage is greater than 0.02

0 Karma
Get Updates on the Splunk Community!

Developer Spotlight with Paul Stout

Welcome to our very first developer spotlight release series where we'll feature some awesome Splunk ...

State of Splunk Careers 2024: Maximizing Career Outcomes and the Continued Value of ...

For the past four years, Splunk has partnered with Enterprise Strategy Group to conduct a survey that gauges ...

Data-Driven Success: Splunk & Financial Services

Splunk streamlines the process of extracting insights from large volumes of data. In this fast-paced world, ...