Calculate and store duration of state field

[si21]

Hi experts, 

How can we calculate and store the duration of a particular state (ex. 'On- Hold' state) in a custom field.

or can we achieve this using PA or reporting?

TIA.

[AndersBGS · Accepted solution]

Hi @si21 ,

No, you should instead create a metric definition to capture the state duration on a specific table, to e.g. capture the "on hold" duration. You can read more about metric definition here : https://docs.servicenow.com/bundle/vancouver-platform-administration/page/administer/time/reference/...

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

best regards

Anders 

[AndersBGS · Accepted solution]

Hi @si21 ,

No, you should instead create a metric definition to capture the state duration on a specific table, to e.g. capture the "on hold" duration. You can read more about metric definition here : https://docs.servicenow.com/bundle/vancouver-platform-administration/page/administer/time/reference/...

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

best regards

Anders 

[Dr Atul G- LNG · Accepted solution]

Hi @si21 

There are OOTB metrics available