Breakdown on 2 levels in PA

adina_dumitresc
Kilo Explorer

Hi,

I would like to make a report in Performance Analytics of type breakdown and vizualization scorecard on 2 levels: first on Assignment Group and second on Manager of the group.

I tried to set Breakdown - Group - and 2nd Breakdown - Manager, when I defined the widget, but is not creating 2 levels; I just get to select from the 2 breakdowns.

find_real_file.png

Second, I would like to change the order - first to have the manager and then the groups in which he is manager and the indicators associated.

Any ideea?

Thanks,

Adina

6 REPLIES 6

Josh Cooper
ServiceNow Employee
ServiceNow Employee

Sure thing!   Make sure, for the indicators that you want to drill down on both on, that you have "Calculate Breakdown Matrix" checked.   That's what allows it to put one breakdown in terms of another.


Hi Josh,



In the indicator I checked the "Collect breakdown matrix" option and I have the 2 breakdowns; I also run again the Job Collector, but still I can'd see the 2 levels in the report.



Do I need to wait for the data to be collected? The indicator is monthly.



Thanks,


Adina


It's possible - I'd make sure the indicator is in the job, and that there aren't any errors in the Job Logs.   I would have thought that it would update on a forced manual collection, but maybe it doesn't.



One thing you can also try, (provided this is a new indicator/score that you're trying to set up, don't do this if you've got data for years!) you can go to the Indicator and view the 'Scoresheet' in the links (not the Scorecard).   On the scoresheet you should see the array with the combinations of the Group/Manager at least represented there, even if there's no data.   But you can also go to the top right corner and "Delete Scores".   Then it should allow it to recollect.   But again, don't lose a ton of data over it - we're almost to the end of the month, it may be worth it to wait!



If you DO have a lot of scores already, you can try recollecting that indicator, by itself on a new Historic job that goes back at least 30 days, to capture the beginning of this month.   But if you use one of the existing Historic jobs, you run the risk of losing/corrupting scores for all the other indicators on the list.



So that's an important note:   When adding new indicators after go-live, make sure the historic collection you run is by itself, because numbers are less accurate on a historic for some indicators than on a daily.


I deleted the scoresheet and run again the job.



In the scoresheet I have separately Assignmnet Group and Manager Group and their scores, but no combinations of Assignmnet Group / Manager Group.


I also created a breakdown relation for Assignment Group > Manager, but still no combinations in the scoresheet.



Adina