Performance analytics Incident Report Query

[Priya080495]

I want to display tabular format data with TOP 20 Business service weekly alongside the incident count per Business service.
Business services with maximum Incidents is categorized as Top Business service and top 20 will be display in the report. 

If this is feasible in Performance analytics, please define approach. 

[Akash4]

Hi Priya,

I would suggest to go from simpler, try out Reporting feature as the data you need already exists on tables.

Quick Steps:

1. Reports > New > Table: Incident, select relevant type of chart/tabular view

2. In configure section, add GroupBy as Business Service & Aggregate as Count

Display colums - Business Service.Name and Incident Count

3. Add additional filters if required.

Limiting to 20 records can be thought of once the above is achievable.

Happy learning!

[priyash]

How to group by aggregate as count? There is not such field as count or option as aggregate in configure section

[Akash4]

That’s true, count is aggregate parameter & not a fied, hence there is no direct way to group by “count”. 
Additionally based on initial requirement, you can sort the report z to a on Incident count, also check if Row Limit available in in Configure section, hopefully without script functions.

[priyash]

Hi Akash, 

This is my report, my only issue now is to get the top 20 business serviceonly to be displayed, currently all business services are displayed with incident count. 
Top 20 must be those with highest incident count. How can this be done?