I was searching this feature, but I did not find it :( I am going to try
to implement something like that.
If there is a way, please get us know.
David
Davis, Gary H wrote:
Is there a way to calculate the average time between states in OTRS?
For example: we would like to know the average ti
Title: Calculating avg. ticket open time by queue
Here is a query to return average ticket
close by category (which is set using freefield1). It should be relatively
easy to adapt this to your needs…
select ifnull(freetext1,'Unclassified'),
avg(TO_DAYS(t.change_time) - TO_DA
