I am trying to calculate the time between status updates.
For example: How long to tickets usually take to go from ticket status "Open" to "Pending"?
I am having difficulties here because there is no time stamp for when a ticket receives the status open, there is only information about how long a ticket stays in a status.
I have tried it with the datasets "Tickets" as well as "Ticket updates" but both of them don't seem to contain the right metrics. I have also tried to calculate the right numbers but that doesn't work because of the missing time stamps.
Is there some other way to retrieve those metrics?
Thanks in advance for the help!