How to build SLA Met vs Breach Report

Column Name Description
Ticket ID Unique identifier
Ticket Type Incident / Service Request
Priority P1 / P2 / P3 / P4
SLA Type First Response / Resolution
SLA Target Configured SLA time
Actual Time Taken Actual response / resolution time
SLA Status Met / Breached
Breach Duration Minutes/Hours breached
Created Date Ticket start
Resolved Date Closure date
Client Name Organization
Assigned Agent Owner

As of now I’m able to get below things except SLA Target, Breach Duration, Actual time taken

Hi,
For Actual Time Taken please check if eazyBI prebuilt SLA Elapsed hours” measure returns the needed result:

For SLA Target and Breach Duration I suggest exploring these two community posts if they provide solutions that fit your requirements:
(1) Time to Resolution elapsed
(2) How can I calculate the contractual penalties for issues that are in SLA breached? - #11 by Absa

Best,
Ilze // eazyBI support team