I have a vertical stacked bar chart with date (month/day) on the x-axis and the number of API calls per individual user as the series. Because I have a large number of users with very few API calls and a few users with a large number for each of them, I want the stack bar segments to just reflect the top 10 individual users with highest API call volume and then lump all others outside of the top 10 into an 'Other' bucket.
The Maximum Items setting in General chart properties does not do want I want. It is instead limiting the chart to 10 daily bars with an 11th bar for all other days.
How to I get Top 10 users with highest API call volumes and then all other users as a single segment of the stacked bar?