Report on proportion of time tickets open by technician

Hi All,

I'd like to put together a report that determines the proportion of time a ticket is open compared to waiting for staff/vendors etc, can you help me to do that?

I've tried doing a matrix - time spent custom report with "Assigned Technician" in the left column and "Time Spent Technician" in the top, with "Summarise" by "Sum" of "Time Spent".

I get the following result with no numbers:

I'm basically wanting to calculate:
1. Complete time all tickets have spent open in one field (even if they are now closed); and
2. Complete time all tickets have spent not open/resolved/closed (ie, sum: Awaiting user, Awaiting Approval, Awaiting Vendor, On Hold, etc) (even if they are now closed) in another field
per technician and total

Thanks!