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!

Exporting Splunk Apps

Join us on Monday, October 21 at 11 am PT | 2 pm ET!With the app export functionality, app developers and ...

[Coming Soon] Splunk Observability Cloud - Enhanced navigation with a modern look and ...

We are excited to introduce our enhanced UI that brings together AppDynamics and Splunk Observability. This is ...

Splunk Smartness with Patrick Tatro | Episode 4

Welcome to another episode of "Splunk Smartness," where we explore how Splunk Education can revolutionize your ...