Dear Team,
Good Day to All, I’m looking for some help into SLA Reports on Task SLA Table.
Request you to please help me with below conditions.
Current Month Breached SLA (%) = (count of requests not resolved in 10 business days in current month / total count of requests created in this month) *100
Current Month Breached SLA (#) = count of requests not resolved in 10 business days in current month
Current Month Mean Closure time (in business days) = Mean of closure time of all resolved requests in current month reported in business days
Count of total breached SLA = count of requests not resolved in 10 business days till date
SLA due in <= 24h = Count of requests that are active and will breach SLA in 24h
SLA due in > 24h - 3days = Count of requests that are active and will breach SLA in > 24h - 3 days
SLA due in > 3-5 days = Count of requests that are active and will breach SLA in > 3-5 days
SLA due in > 5 days = Count of requests that are active and will breach SLA in > 5 days
