Report

Report

hi all, i have this report, this report show me all incidents avg. but i want I priority avg, II priority avg and etc. it is possible? please help me thank you






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 limit 50000
              New to ADManager Plus?

                New to ADSelfService Plus?