Time Rules

[Arthur Sanchez]

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?

[Arthur Sanchez · Accepted solution]

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.