Time until first take


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?