t, so I don't know if and when I'll do this.
Gabriele
- Original Message -
From: Tabitha Stang
To: otrs@otrs.org
Sent: Friday, December 21, 2007 4:06 PM
Subject: [otrs] calculating answer time
Hi,
We'd like to be able to calculate the time it take
Hi,
I sent this a few days ago, but unfortunately haven't received a response.
Maybe because it's not possible?
We'd like to be able to calculate the average time it takes for us to answer
a ticket.
I found code in the logs, but it has one problem, best illustrated through
an example:
Hi,
We'd like to be able to calculate the time it takes for us to answer
tickets.
I found the following code in the logs (slightly modified):
SELECT ticket.tn, timediff(ticket_history.create_time, ticket.create_time)
AS 'diff' from ticket LEFT JOIN ticket_history ON
ticket.id=ticket_hist