Hi All,

I was wondering if anyone knows or can point me in the right direction on how to report on completed tasks by technician?

Ideally i would like a pie chart on how many tasks each technician has completed/closed for the previous month

Included in the report i would like

Task Id

Requester

Technician/owner - Not really sure the difference

date completed.

PGSQL is being used.

I have something similar for service requests using the report wizard the query is as below:

SELECT ti.FIRST_NAME AS "Technician", wo.WORKORDERID AS "Request ID", ti.FIRST_NAME AS "Technician", mdd.MODENAME AS "Request Mode", aau.FIRST_NAME AS "Requester", dpt.DEPTNAME AS "Department", cd.CATEGORYNAME AS "Category", wo.TITLE AS "Subject" FROM WorkOrder wo LEFT JOIN ModeDefinition mdd ON wo.MODEID=mdd.MODEID LEFT JOIN SDUser sdu ON wo.REQUESTERID=sdu.USERID LEFT JOIN AaaUser aau ON sdu.USERID=aau.USER_ID LEFT JOIN DepartmentDefinition dpt ON wo.DEPTID=dpt.DEPTID LEFT JOIN WorkOrder_Queue woq ON wo.WORKORDERID=woq.WORKORDERID LEFT JOIN QueueDefinition qd ON woq.QUEUEID=qd.QUEUEID LEFT JOIN WorkOrderStates wos ON wo.WORKORDERID=wos.WORKORDERID LEFT JOIN CategoryDefinition cd ON wos.CATEGORYID=cd.CATEGORYID LEFT JOIN SDUser td ON wos.OWNERID=td.USERID LEFT JOIN AaaUser ti ON td.USERID=ti.USER_ID LEFT JOIN StatusDefinition std ON wos.STATUSID=std.STATUSID WHERE  ( ( ( std.STATUSNAME = 'Closed' ) AND ( qd.QUEUENAME = 'Service Desk Team' ) ) AND ( ( ( wo.CREATEDTIME >= 1606780800000 ) AND ( ( wo.CREATEDTIME != 0 ) AND ( wo.CREATEDTIME IS NOT NULL ) ) ) AND ( ( wo.CREATEDTIME <= 1609459199000 ) AND ( ( ( wo.CREATEDTIME != 0 ) AND ( wo.CREATEDTIME IS NOT NULL ) ) AND ( wo.CREATEDTIME != -1 ) ) ) ) )  AND wo.ISPARENT='1'  ORDER BY 1

Thanks all for any help much appreciated