Custom Query for Closed / Resolved Previous week
Hi all, i have the following query which works for the resolved but i would also like to include closed
What would be the best way to incorporate both resolved and closed in to the report
Thanks in advance
select MAX(aaa.first_name) "Resolved By", COUNT(Distinct workorderid) "Count of requests" from workorderhistory woh left join aaauser aaa on woh.Operationownerid=aaa.user_id where operation='Resolved' and woh.OperationTIME >= <from_lastweek> AND woh.OperationTIME <= <to_lastweek> GROUP BY aaa.USER_ID limit 50000
What would be the best way to incorporate both resolved and closed in to the report
Thanks in advance
select MAX(aaa.first_name) "Resolved By", COUNT(Distinct workorderid) "Count of requests" from workorderhistory woh left join aaauser aaa on woh.Operationownerid=aaa.user_id where operation='Resolved' and woh.OperationTIME >= <from_lastweek> AND woh.OperationTIME <= <to_lastweek> GROUP BY aaa.USER_ID limit 50000