Join the #BuildWithBuildAgent Challenge! Get recognized, earn exclusive swag, and inspire the ServiceNow Community with what you can build using Build Agent.  Join the Challenge.

Time Rules

Arthur Sanchez
Giga Guru

Hey guys, I have to make charts and dashboards where I can show the time difference between the status changes from one ticket to another.

For example, a ticket was opened and took 2 hours to become pending, and from pending it took 1 hour to be put in progress and 4 hours to close.

I didn't quite understand how to do this in a chart, so I was thinking about creating new columns and using Business Rules to do the calculation, but I still don't know how to do this either.

If anyone has already done this or knows a better way, could you help me?

1 ACCEPTED SOLUTION

Arthur Sanchez
Giga Guru

The trick is to use a BR to get the update time from when it changes from pending to in progress and then get the time difference from that value.

View solution in original post

1 REPLY 1

Arthur Sanchez
Giga Guru

The trick is to use a BR to get the update time from when it changes from pending to in progress and then get the time difference from that value.