Creating New Query Reports :)

Creating New Query Reports :)

Dear Team:

I need a Query report on how long a request takes to go from unassigned to assigned and how long it takes to go from assigned to Compeleted .

Available Columns :

Requester,Technician,Subject,Category,Priority,Created Time,Assigned Time,Completed Time

Filter Options :

Date Filter from xxxxx to xxxxx

Group by :

Technician time

summary type :

Average of (Time Spent from unassigned to assigned ) and then (Time Spent from assigned to Compeleted )
 
Please Help me

Regards

N.M

                  New to ADSelfService Plus?