How to calculate the time spent by a change request in each state of the state ?

snehalkhare
Kilo Guru

Hi All,

As mentioned in the question I need to calculate the time spent by a change request in each state of the state. 

For example the state are New , Assess , Validate and so on . I need to calculate the time for how long the change request was in the New state. this time is to be stored in different fields for each state.

How can this be achieved?

 

Thanks,

Snehal 

 
Topics: 
1 ACCEPTED SOLUTION

Michael Fry1
Kilo Patron

I would build a new Metric similar to this:

find_real_file.png

View solution in original post

5 REPLIES 5

Sunil B N
ServiceNow Employee
ServiceNow Employee

Hi Sneha,

At the moment, we don't have infrastructure OOTB to capture time worked at each state of the task. This is quite interesting use-case which we will consider in our future road map.
If you would like to achieve this, you may need a separate table where you can capture time worked based on change of state against the task..
Best regards,
Sunil B N