The CreatorCon Call for Content is officially open! Get started here.

Performance Analytics - breakdown on a string field does not show results in a scorecard

mitzaka
Mega Guru

Hi SNC,

I need some help with PA breakdowns. Here is my case: I am trying to show a scorecard that lists different CI classes and their versions (version is a custom string field I have on the cmdb_ci table). I have created a manual breakdown which collects my entries for the 'version' field, and then I have a script which basically relates my manual breakdown to an automated breakdown called 'CI Version', which is attached to few of my indicators.

For creating the CI Version breakdown entries, I am basically using a similar approach like the one stated here: Creating an automated drill-down breakdown by assignment group & group member

So I check my scorecard, I can see records populated when I use the CI Class breakdown (which is another breakdown I have created the same way).

Screen Shot 2017-07-26 at 11.32.51 AM.png

Then I click on some of the CI Classes, expecting that I would be able to use another breakdown for the 'CI Version' in each class. However, when I click on the 'CI Version' breakdown, I don't see anything loading in the record list. What is strange, however, is that when you click on the 'element' list option, you can see the different versions, which means that the data is being read, but not presented.   Any ideas on how to fix that are more than welcome

Screen Shot 2017-07-26 at 11.36.50 AM.png

1 ACCEPTED SOLUTION

mitzaka
Mega Guru

I think I have just found my solution - I have made an error in my PA script. Instead of having 'current.u_version' I had 'cmdb_ci.u_version' which was throwing back an error and was preventing the records from being associated with the breakdown.



Once I updated the script and re-ran the PA job everything works fine now.


Here is how it looks;))) - broken down by version in a CI Class


Screen Shot 2017-07-26 at 12.39.17 PM.png


View solution in original post

5 REPLIES 5

Arnoud Kooi
ServiceNow Employee
ServiceNow Employee

Did you ena le collect breakdown magrix for the indicator?


Yes, absolutely, I have enabled it.


mitzaka
Mega Guru

I think I have just found my solution - I have made an error in my PA script. Instead of having 'current.u_version' I had 'cmdb_ci.u_version' which was throwing back an error and was preventing the records from being associated with the breakdown.



Once I updated the script and re-ran the PA job everything works fine now.


Here is how it looks;))) - broken down by version in a CI Class


Screen Shot 2017-07-26 at 12.39.17 PM.png


Josh Cooper
ServiceNow Employee
ServiceNow Employee

Awesome!   Thanks so much for posting the resolution!