SLA Reports Due Date Conditions

[_Samay]

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

[AndersBGS]

Hi @_Samay ,

According to your requirement, you have some different calculations, hence the reporting should be done in performance analytics if you have that available? If yes where do you get stuck in your requirement and what have you tried?