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!

New This Month in Splunk Observability Cloud - Metrics Usage Analytics, Enhanced K8s ...

The latest enhancements across the Splunk Observability portfolio deliver greater flexibility, better data and ...

Alerting Best Practices: How to Create Good Detectors

At their best, detectors and the alerts they trigger notify teams when applications aren’t performing as ...

Discover Powerful New Features in Splunk Cloud Platform: Enhanced Analytics, ...

Hey Splunky people! We are excited to share the latest updates in Splunk Cloud Platform 9.3.2408. In this ...