Hi All,
I need help to get SLA achieved report in following format:
| Urgency | Total Incidents | Escalated | TTA met | TTN met | TTE met |
| High | 58 | 34 | 89.3% | 89% | 99% |
| Medium | 70 | 23 | 78% | 50.40% | 29% |
| Low | 113 | 3 | 40% | NA | 40% |
| Info | 405 | 10 | 98% | NA | NA |
Here TTA ,TTN and TTE are SLA definitions configured in a system. However total incidents and escalated is from incident table.
Formula to calculate percentage is [(Has Breached is false) / (Total no. of SLA attached)] *100
Thanks for your help in advance.
