I would like to make a pie chart which shows the Top 10 tenants by number of hosts and then put everything else under the label "other". Currently, I am doing this: | stats sum(hostsCount) as hostsCount by TenantName
| sort hostsCount desc The issue with this is that it truncates the TenantNames to 10000 as shown in the screenshot which makes the "other" category's hostsCount not accurate. There are over 30000 TenantNames/hostsCount. I would like to change this Pie chart to: 1. Display the Top 10 tenants by hostsCount 2. Make a label called "other" and put all the remaining hostsCounts in them so that it displays the accurate percentage/amount. What would be the best way to do this?
... View more