Hi,

I am creating the following report, however I need another column at the end which shows the days it has taken to resolve and also another report which has the hours taken to resolve.

So:

-  Response days = Respond date - Created time, 

-  Response Time = Respond date - Created time, 

SELECT ti.FIRST_NAME "Technician",

qd.QUEUENAME "Group",

TO_CHAR(((avg(wos.assignedtime)-avg(wo.createdtime))/1000 || ' second')::interval, 'HH24:MI:SS') "Avg Assigned Time",

TO_CHAR(((avg(wo.resolvedtime)-avg(wo.createdtime))/1000 || ' second')::interval, 'HH24:MI:SS') "Avg Resolvedtime Time",

TO_CHAR(((avg(wo.RESPONDEDTIME)-avg(wo.createdtime))/1000 || ' second')::interval, 'HH24:MI:SS') "Avg RESPONDEDTIME Time" FROM WorkOrder wo LEFT JOIN WorkOrderStates wos ON wo.WORKORDERID=wos.WORKORDERID LEFT JOIN SDUser td ON wos.OWNERID=td.USERID LEFT JOIN AaaUser ti ON td.USERID=ti.USER_ID LEFT JOIN CategoryDefinition cd ON wos.CATEGORYID=cd.CATEGORYID LEFT JOIN WorkOrder_Queue woq ON wo.WORKORDERID=woq.WORKORDERID LEFT JOIN QueueDefinition qd ON woq.QUEUEID=qd.QUEUEID WHERE (wo.ISPARENT='1')  and wos.assignedtime !=0 and wo.RESPONDEDTIME!=0 and wo.resolvedtime!=0 and wo.CREATEDTIME >= <from_thisweek> AND wo.CREATEDTIME <= <to_thisweek> group by ti.FIRST_NAME,qd.QUEUENAME

Thanks

Rachell