How to bring assigned to duration metric in Reports?

[vaishnav]

I want to create a report where the assigned to's duration is shown, like for how long the incident was with him when he reassigned to someone else?  

I know we can use assigned to duration metric but how to use that on reports?

[Maik Skoddow]

Hi @vaishnav 

Reporting on a metric is done using the database view that links the metric to the table on which it is defined. You should create a database view on the Metric Instance table and the related table that you want to report. OOTB there is already a database view on incident metrics. Maybe it already provides what you need: /nav_to.do?uri=sys_db_view.do?sys_id=2d722c6b0b01010100c3122d2939e03b
And in the follow video you can see how to report on such a database view: https://www.youtube.com/watch?v=_tkBUCuNYes 

Maik

[AndersBGS]

Hi @vaishnav ,

From my perspective you have two different possibilities. either you can create a metric definition based on the assigned two, and afterwards create a report based on the metric definition created. Alternative you can activate the plugin SLA breakdown defintions: https://docs.servicenow.com/en-US/bundle/vancouver-it-service-management/page/product/service-level-...

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

best regards

Anders

[AndersBGS]

Hi @vaishnav ,

If my answer has helped with your question, please mark my answer as accepted solution.

best regards

Anders

[Curt4]

Hi @vaishnav , 
Just by chance have you tried a Pivot Table Report?  Make the Row like the category field, then the Column set to Assigned to, and then under Aggregation change that to SUM and pick Business Duration.
See if that works for you.