Performance Analytics Report

[ashishkathait]

I want to create a report for a person named ABC. ABC is listed as a manager on the user table with 10 direct reports. Each of those 10 people are managers of 100 more users, and so on. How can I create a report that shows all incidents assigned to users who fall under Manager ABC in this reporting hierarchy? In addition, the manager should be able to view the report on a dashboard, showing the breakdown by each of their 10 direct reports, so they can see the incident numbers for each one individually.

[Ankur Bawiskar]

@ashishkathait 

Hope you are doing good.

Did my reply answer your question?

If my response helped please mark it correct and close the thread so that it benefits future readers.

[Anand2799]

Hi @ashishkathait ,

You can build report using scripting as Ankur suggested, however if you are on Zurich release or planning to upgrade to zurich then checkout this new feature Building Hierarchical Queries introduced by ServiceNow, this fulfills the same requirement as yours.

Building hierarchical queries 

I think this was first introduced in Yokohama but was made inactive due to technical issues, if you are on this release verify if this was made active in any of the patches.

Thanks

Anand