Splunk Search

"Other" option in pie chart

geetanjali
Path Finder

I am displaying my 20 hosts in pie chart using following query:-

index="test" sourcetype="power_usage" | chart first(Power_consumption) over host | sort 20 -first(Power_consumption)

"Other" is not coming in chart. How could i display "other" in my chart. I am using Pie chart to display my data.

Tags (1)
0 Karma

lostpassword
Explorer

try

top 5 ... useother=t

instead of

chart limit=5
0 Karma

Ant1D
Motivator

The following search includes the 'limit' search command. This should bring back the 5 field values + the OTHER field:

index="test" sourcetype="power_usage" | chart limit=5 first(Power_consumption) over host | sort 20 -first(Power_consumption)

geetanjali
Path Finder

Hello,
Thanks for the response. but limit command is not working in "Chart". thie query is giving same result. displaying 20 hosts data in pie chart. But no "others" displayed in chart

0 Karma
Get Updates on the Splunk Community!

See just what you’ve been missing | Observability tracks at Splunk University

Looking to sharpen your observability skills so you can better understand how to collect and analyze data from ...

Weezer at .conf25? Say it ain’t so!

Hello Splunkers, The countdown to .conf25 is on-and we've just turned up the volume! We're thrilled to ...

How SC4S Makes Suricata Logs Ingestion Simple

Network security monitoring has become increasingly critical for organizations of all sizes. Splunk has ...