Query for specific technician response performance

Hello,

I've been asked to pull a report on how quickly a technician is able to resolve/close (or reassign) tickets that have been assigned to them. Specifically, the requirements need a report broken out by technician that provides the total number of tickets for the last year and what percentage of those tickets were either resolved, closed, or reassigned within 24 hours of that ticket actually being assigned to that technician.

I'm not too interested in when the ticket was actually opened, but rather the '24 hour clock' should start when the ticket was actually assigned to that technician.

Also, I'm not sure how to handle the 'reassignment' part of the requirement since the ticket only really tracks the 'current' (or 'last') technician on the ticket itself. Is this even possible?

Regards