Can someone modify this repor ?

 

I'd like to use "lastmonth", "lastquarter", "lastweek", etc.

 

select count(a.workorderid)"Total Request Count",SUM(a.isoverdue)"SLA Violated Request Count" ,sum(!a.isoverdue)"SLA Not Violated Request Count",
(sum(!(a.isoverdue || a.ispending)) /count(a.workorderid))*100 "% Calls Closed within SLA"
from (select wos.*,sd.ispending from workorder wo inner join workorder_threaded wot on wot.workorderid= wo.workorderid left join workorderstates wos
on wo.workorderid = wos.workorderid left join statusdefinition sd on
wos.statusid= sd.statusid where wo.slaid is not null && wot.workorderid=wot.thd_woid && (DATEDIFF(Now(),(from_unixtime(wo.CREATEDTIME/1000)))<=90)) as a

 

Thanks in advance,

 

Richard Baltus