How to find the duration a field is put on a specific value during the duration of the case

[Community Alums]

I have a custom Choice field called as "Next Action" with dropdown values as "test", "QA" and "Prod".

I need to find out the duration of how much time till the case is closed, the "Next Action" was holding the value as "Prod".

Can someone tell how to achieve this?

[Joni V B]

Hi @Community Alums ,

To keep track of the duration a certain field holds a value, you could use Metrics.

https://docs.servicenow.com/auth/login/?redirect=%2Fbundle%2Fxanadu-platform-administration%2Fpage%2Fuse%2Freporting%2Fconcept%2Fc_MetricDefinitionSupport.html

Best regards,

Joni