How to calculate total time duration of pending status in incident

[komuru]

We are trying to calculate total time duration in pending status

[Murthy Ch]

@komuru 

You can use metric definitions which is OOB functionality to calculate the time of the pending status

Thanks,

Murthy

[Ankur Bawiskar]

Hi,

you can incident metrics for this

Already there is 1 OOB for incident

Name: Incident State Duration

It would tell incident was in Pending, On Hold etc for how much duration

Table which holds this - incident_metric

Regards
Ankur

[SN Emy]

Hey Ankur,

I need to do the same thing on the Idea and Demand tables.

We use some stats from the task table + new custom stats

The new stats are not taken into consideration.

Do you have an idea?