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="powerusage" | chart first(Powerconsumption) over host | sort 20 -first(Powerconsumption)
<module name="FlashChart" layoutPanel="panelrow2_col1" >
What option i need to include for displaying "Others" in pie chart?
Thanks in advance.
This will work:
index="test" sourcetype="power_usage" | chart limit=20 useother=t first(Power_consumption) over host