Join the #BuildWithBuildAgent Challenge! Get recognized, earn exclusive swag, and inspire the ServiceNow Community with what you can build using Build Agent.  Join the Challenge.

How to Utilize Custom Metric Definitions

jasonchavez
ServiceNow Employee
ServiceNow Employee

Hello,

 

There exists a few metric definitions that I want to display/utilize/track. For example, there is this metric definition that was created that tracks: "How long an agile story in rm_story was in each respective state". This is a great metric.

 

How do I utilize it? For example, how do I show these metric definitions for my agile stories in the rm_story table? What do I need to do to integrate these metrics?

1 ACCEPTED SOLUTION

Prithvi_b
Tera Guru

Hi @jasonchavez ,

 

You can use this metric definition for reporting purposes. You can create a Database view connecting metric_instance table and rm_story table with a key field that connects both tables. Based on this database view, you can create reports.

(Adding screenshots where I created database view for task and metric_instance table. Added some conditions too.).
 

Thankyou,

prithvi

View solution in original post

1 REPLY 1

Prithvi_b
Tera Guru

Hi @jasonchavez ,

 

You can use this metric definition for reporting purposes. You can create a Database view connecting metric_instance table and rm_story table with a key field that connects both tables. Based on this database view, you can create reports.

(Adding screenshots where I created database view for task and metric_instance table. Added some conditions too.).
 

Thankyou,

prithvi