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)

[Michael Culhan1]

I ended up creating a scorecard widget for each assignment group.... kind of clumsy but clumsy is the norm in PA 😞 

[AndersBGS]

Hi @Michael Culhan1 ,

The second breakdown on a widget is "just" an additional filter to the first widget. Basic, this will not give you the view that you're looking for. Instead, I would agree with @Tai Vu on the pivot table in the report designer if you want to see incidents by  users and by assignment groups. 

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

Best regards

Anders

[Michael Culhan1]

Thanks.  Is it possible to display PA data (indicators, breakdowns) in the regular report designer?

[AndersBGS]

Hi @Michael Culhan1 ,

No, it is not - it's two different solutions.

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

Best regards

Anders