"Other" option in pie chart

[geetanjali]

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.

[lostpassword]

try

top 5 ... useother=t

instead of

chart limit=5

[Ant1D]

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]

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