Performance/Platform Analytics - Chart Grouped by IT leader and Stacked by Patch Status - HELP!!

[Keith Hnasko]

Hey there,

I'm on the Vancouver release of ServiceNow and I'm a Performance Analytics Admin. I need help with a specific issue. I'm trying to create a report similar to the one I’ve attached, which uses two breakdowns/group bys. I need to achieve this in either Performance Analytics or Platform Analytics, preferably in Performance Analytics.

Here’s the situation: I was asked to implement some custom logic for grouping and custom labels, which I accomplished using a breakdown script. It all functions great, but I can’t find any widget or method in Performance Analytics to create a bar chart (or any chart besides a pivot table) that displays data by IT leader and further groups it by Patch Status. Essentially, I need to show data by two levels.

I have enabled the collect breakdown matrix and tried adding it into the "2nd breakdown" box, but it doesn’t function correctly. Can you help me find a way to achieve this? I even checked Platform analytics and I don't even see an option to do this either. Really frustrating!! I really don't want to use a pivot table because I can't use custom colors for labels in a pivot table and I can't use a filter if i want to only show one name.  Side note, I removed names with black-out for privacy sake. 

 

[Keith Hnasko]

Also I did more experimenting, I went into platform analytics and it seems if you use any table as a DataSource you can accomplish this double group by (stack by + group by) however as soon as you change that data source to an indicator source the ability to do it goes away, seems insanely odd and the value gained by having the flexibility to do the same thing on a standard table DataSource as an indictor DataSource in platform analytics would be huge.