Hi @niketn Your approach got me towards the result I wanted! I ended up with this run everywhere example to sort the pie chart trellis sorted the way I needed them | tstats count WHERE index=_* by index sourcetype
| eval my_range=case(count > 0 AND count < 500, 1,count > 500 AND count < 1000, 2,count > 1000 AND count < 2000, 3, 1=1, 10)
| stats dc(sourcetype) AS st dc(index) AS idx by my_range
| sort - my_range
| streamstats count as sno
| eval something=sno.". ".my_range
| stats sum(st) AS st sum(idx) AS idx by something Thanks and I hope this will help some one else while we wait for the fix ... cheers, MuS
... View more