Hi there. I have a Trend report that shows the number of incidents by category trended over the last 3 months (see below).
I need to limit the number of categories (i.e. groupings within each month's stack) to the Top 10, to make the report more readable and avoid there being more categories than can be shown on the legend.
There is a "Max Number of Groups" field (see below), but this appears to work against the X-axis (i.e. the months) instead of the categories.
Does anyone have a workaround or solution for this issue - or have you seen it before and concluded (like me) that it can't be done .. ?
I know Performance Analytics will let you do it in a widget using the "show top x" elements.
Show all:
Adding this setting:
Limits the graph:
So you could use that, it works for "Created by monthly", even though my example is "Open by daily". The problem is that it bases the "top x" on the latest score, not what the "top X" was for each month.
Another solution would be to create a a scripted filter that uses glideAggregate to count the number of incidents for each category, and return the top 10 categories. Then return all the incidents belonging to those categories in an array.
