Splunk Search

How to include "Other" in pie chart.

geetanjali
Path Finder

I have total 100 host data. But i am displaying 20 hosts in my pie chart with sort 20 command. I want other option to display remaining hosts.


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


True


True
False

pie

100%





What option i need to include for displaying "Others" in pie chart?

Thanks in advance.

Tags (1)
0 Karma

woodcock
Esteemed Legend

This will work:

index="test" sourcetype="power_usage" | chart limit=20 useother=t first(Power_consumption) over host 
0 Karma
Get Updates on the Splunk Community!

.conf24 | Registration Open!

Hello, hello! I come bearing good news: Registration for .conf24 is now open!   conf is Splunk’s rad annual ...

ICYMI - Check out the latest releases of Splunk Edge Processor

Splunk is pleased to announce the latest enhancements to Splunk Edge Processor.  HEC Receiver authorization ...

Introducing the 2024 SplunkTrust!

Hello, Splunk Community! We are beyond thrilled to announce our newest group of SplunkTrust members!  The ...