Summary report for SLA compliance for KPI
I have this query below to show if SLA is being met. But I want the columns to be displayed like these
| Category |
Resolved within SLA |
Resolved after SLA |
Total Resolved tickets |
| Computer | 2 | 17 | 19 |
| Network | 0 | 2 | 2 |
| Not Assigned | 0 | 0 | 0 |
| Others | 40 | 54 | 94 |
| Printers | 3 | 2 | 5 |
| Total | 45 | 75 | 120 |
And 2 other columns showing the percentage of tickets resolved within sla against the total tickets and percentage of tickets resolved after sla against the total. And as per the query we should be able to define the date range. So that we can generate per week per month basis.
