Calculating how much time elapsed on each state ON INCIDENT

[Abishek1998]

Hi all,

So incident form goes to various states like inprogress, hold etc., So i want to calculate the time spent on each states.

I have tried it with business rule but didn't workout.

[Ravi Gaurav · Accepted solution]

Hi @Abishek1998 

Can you share what you have tried?

You can create two custom fields:

Create Fields:

• Add a field like u_state_entry_time (Date/Time type) to the incident table to store when the state changed.
• Add another field u_state_duration (Duration type) to store how long the incident was in that particular state.

And Write before BR

Condition: current.state.changes()

var now = new GlideDateTime();
var stateEntryTime = current.u_state_entry_time;

if (!stateEntryTime.nil()) {
var durationInPreviousState = gs.dateDiff(now, stateEntryTime, true); 
current.u_state_duration = durationInPreviousState; 
}current.u_state_entry_time = now;

[Abishek1998]

So can you please guide me in step by step process? of what to do ?