Query Report Not displaying all ServiceDesk Info

I'm running the below report and getting results but only showing one of the 2 groups we have and only showing 1 of 4 priorities, I can't work out why it's not displaying everything.

ServiceDesk 9.4 9400 MS SQL

SELECT qd.QUEUENAME 'Group',pd.PRIORITYNAME "Priority" , convert(varchar(10),(avg(woh.operationtime-wo.createdtime))/1000/3600)+':'+convert(varchar(10),((avg(woh.operationtime-wo.createdtime))/1000)%3600/60)+':'+convert(varchar(10),(((avg(woh.operationtime-wo.createdtime)))/1000%60)) as Average_Resolution_Time , convert(varchar(10),(max(woh.operationtime-wo.createdtime))/1000/3600)+':'+convert(varchar(10),((max(woh.operationtime-wo.createdtime))/1000)%3600/60)+':'+convert(varchar(10),(((max(woh.operationtime-wo.createdtime)))/1000%60)) as Max_Resolution_Time,
convert(varchar(10),(min(woh.operationtime-wo.createdtime))/1000/3600)+':'+convert(varchar(10),((min(woh.operationtime-wo.createdtime))/1000)%3600/60)+':'+convert(varchar(10),(((min(woh.operationtime-wo.createdtime)))/1000%60)) as Min_Resolution_Time from workorder wo
left join workorderhistory woh on wo.workorderid=woh.workorderid LEFT JOIN WorkOrderStates wos ON wo.WORKORDERID=wos.WORKORDERID LEFT JOIN PriorityDefinition pd ON wos.PRIORITYID=pd.PRIORITYID LEFT JOIN WorkOrder_Queue woq ON wo.WORKORDERID=woq.WORKORDERID LEFT JOIN QueueDefinition qd ON woq.QUEUEID=qd.QUEUEID
where woh.operation='resolved' and
dateadd(s,datediff(s,GETUTCDATE() ,getdate()) + (wo.createdtime/1000),'1970-01-01 00:00:00') >= convert(varchar,'2018-01-01 00:00',21) and dateadd(s,datediff(s,GETUTCDATE() ,getdate()) + (wo.createdtime/1000),'1970-01-01 00:00:00') <= convert(varchar,'2018-02-28 23:59',21)
group by qd.QUEUENAME,pd.PRIORITYNAME

Thanks