Dashboards & Visualizations

How to calculate the percent of a value from total?

JohnnyMnemonic
Explorer

Hi splunkers,

I thought it would be easier, but now I need to ask you for help.

I need to make a simple tart chart with the percent of an IP Address and the percent of all other together as "Other".

How can I group all values in a single value "other" but leaving out just the value I want to analyze?

Thanks!

Labels (3)
Tags (1)
0 Karma
1 Solution

SanjayReddy
SplunkTrust
SplunkTrust

Hi @JohnnyMnemonic 

are you expecting output like below , then please use pie chart

SanjayReddy_0-1646741305564.png

have you condsied using cidrmatch?. 

SanjayReddy_1-1646742258149.png

 

View solution in original post

JohnnyMnemonic
Explorer

I am currently using this query but it seems a bit hard for the search head:

index=logs sourcetype=more_logs dest_ip=*
| eval address=IF(LIKE(dest_ip, "0.0.0.0"), "YES", "OTHER")
| stats count by address

0 Karma

SanjayReddy
SplunkTrust
SplunkTrust

Hi @JohnnyMnemonic 

are you expecting output like below , then please use pie chart

SanjayReddy_0-1646741305564.png

have you condsied using cidrmatch?. 

SanjayReddy_1-1646742258149.png

 

Get Updates on the Splunk Community!

Index This | I’m short for "configuration file.” What am I?

May 2024 Edition Hayyy Splunk Education Enthusiasts and the Eternally Curious!  We’re back with a Special ...

New Articles from Academic Learning Partners, Help Expand Lantern’s Use Case Library, ...

Splunk Lantern is a Splunk customer success center that provides advice from Splunk experts on valuable data ...

Your Guide to SPL2 at .conf24!

So, you’re headed to .conf24? You’re in for a good time. Las Vegas weather is just *chef’s kiss* beautiful in ...