I nned Metric From Frist assigment group Update to ticket closed

[sivananda80]

Hi Team,

I want to create a metric on the ticket table that calculates the duration from when the Frist "Assigned Group is update to when the ticket is Closed.

can you please help me

Thank you
Siva

[sivananda80]

Thank you for quick response. 

I need only from "First assignment group updated to Closed ticket"

[Tanushree Maiti]

You can check  metric_definition table. OOB it calculates the duration of time an incident is assigned to an assignment group or user, who it's assigned to etc.

If you are  looking in the related lists section it will have all the records it creates for that particular definition. Those records exist on the metric_instance table. 

So create your report on the metric_instance table and in the condition builder choose "Definition is assigned to duration" and "table is incident." In columns add "value, ID, duration," and then group them by ID