I need a scripted breakdown that will dot-walk from metric_instance to the ID field to fields that are on that document ID

Go to solution
George P
Tera Guru

‎02-20-2020 11:03 AM

I am attempting to create a breakdown that looks at certain records on the metric_instance table and breaks down on the ID.User field.  Can someone provide some guidance on how I would make a script dot-walk through a document ID field?

Labels:
0 Helpfuls
  • 1,844 Views
1 ACCEPTED SOLUTION

Go to solution
Adam Stout
ServiceNow Employee
ServiceNow Employee

‎02-20-2020 12:22 PM

Don't use a script for this.  You'll get much better performance if you create a view to the table you are looking for (e.g., incident, case, etc.) and then build your indicator on that.  There was a lab on this at K19 which walks you though using Performance Analytics on metrics. (I believe it is this one: https://community.servicenow.com/community?id=community_article&sys_id=686623dcdb9d3b0422e0fb2439961...)

View solution in original post

0 Helpfuls
5 REPLIES 5

Go to solution
Adam Stout
ServiceNow Employee
ServiceNow Employee
In response to George P

‎03-02-2020 08:36 AM

Analytics is a team sport.  To get the Performance Analytics to do what you need it to, there will be use cases when changes to the application (like a database view) are required.

0 Helpfuls