2nd Breakdown on Performance Analytics Breakdown widget

[Michael Culhan1]

Is it possible to see the 2nd Breakdown in a Performance Analytics Breakdown widget?  I'm trying to achieve a pivot table style with the structure below:

-Assignment Group 1

 --User 1

 --User 2

-Assignment Group 2

 --User 3

 --User 4

This question seems to indicate that it is possible https://www.servicenow.com/community/platform-analytics-forum/breakdown-on-2-levels-in-pa/m-p/125407...

However this docs page indicates that the 2nd Breakdown is a filter

https://docs.servicenow.com/bundle/washingtondc-now-intelligence/page/use/performance-analytics/conc...

I have the Calculate Breakdown Matrix enabled and a relationship between the breakdowns.  When I add a 2nd Breakdown to the widget, it acts like a filter (as the documentation page linked above explains)

[Tai Vu]

Hi @Michael Culhan1 

There's a pivot report type available within the Report module that can give you a quick view of assignment groups and their assignees, it seems similar to what you're looking for. Sample:

Is there any specific reason you're not using this report type for your needs? Can you share more details?

Cheers,

Tai Vu

[Michael Culhan1]

Thanks for the response.  I'm looking to display a PA indicator like the below.  I don't think this is possible in a regular report, only a PA widget.

[AndersBGS]

Hi @Michael Culhan1 ,

Yep, only PA, but then the columns will be by date - not by assignment group etc. as you requested. 

If my answer has helped with your question, please mark my answer as accepted solution and give a thumb up.

Best regards

Anders

[Tai Vu · Accepted solution]

Hi Michael,

You can build a pivot scorecard widget in PA, but it won't be quite like the visualization in your screenshot. Reference below:

Create a pivot scorecard visualization for a breakdown widget

Additionally, if there aren't too many groups in your scenario, you could consider create scorecard widgets for each Group (similar to your screenshot) then break down by Assignee. 

Cheers,

Tai Vu