Hi,I'm trying to get a report of the average time for the first owner change transaction in a ticket. Is there a way of achieving this using TicketSQL or would I have to use something external to RT to make a query to the database directly?
My idea is to grab all the 'owner change' type of transactions for a ticket keeping just the first one, and calculate the difference between this event and the 'created' time for the ticket.
Does this make any sense? Thanks, David
