Reporting duration time - excluding On Hold time

[VeraO]

Dear Team,

I would like to request a metrics report that shows the duration of time a task spends assigned to a given assignment group, excluding any time when the status is "On Hold" or "Pending."

We can track the state changes in the field history, so it should be possible to capture the relevant timestamps. Specifically, we are interested in measuring the duration only when the status is "Open" or "Work in Progress."

Is it possible to capture this information? If so, could you please assist with the necessary script to generate this report?

Thank you very much for your assistance.

Kind regards,

Vera

[Prasanna_Patil]

Hi @VeraO In the metric definition itself you can archive this  may be

[AndresU]

Hello - Can you please be more clear? I am looking for this solution because I want to calculate duration - "time suspended". What do you mean by "in the metric definition"?

[Bert_c1]

https://docs.servicenow.com/bundle/xanadu-platform-administration/page/use/reporting/concept/c_Metri...

There are plenty of OOB examples in your instance.