PA report Queri to fetch top 20 incidents

[priyash]

I am using classic report to count the number of incidents per Business service in a week and the report is shown in image. 

However, I want to only display the top 20 Business service with highest incident count per week.

Is this doable in PA, please suggest how?

#performanceanalytics #reporting #itsm

Regards

[Uncle Rob]

MUCH harder to do in PA, depending on your visualization.

Lets say you pick a PIE chart.  That's only going to look at a single score in your score sheet, so just picking the number of groups will suffice.
Now, lets say you want to do a bar chart stacked by your "top 20" groups.   What happens if the Top20 from the day before yesterday is different from yesterday and that's different from today?

There's no guarantee that OVER TIME you'll have the same TopX grouping.

So the TopX is only useful for static points in time.

[Uncle Rob]

IF (and only if) you've got some static list of Top20 already defined, you COULD build an annoying workaround.
Lets say you've already decided the 20 services you want to look at are.
You could put on ONE visualization with 20 separate widget indicators, each featuring its own breakdown element (one for each Service).

Labor intensive AND it works.

You can do the same thing in Platform Analytics Center for a lot less labor... but the original design problem I outlined persists.