Routine~14min

The Ignored SLA

The support dashboard reports an 89% SLA compliance rate. But when you calculate actual resolution times from the raw data, the number looks very different. A batch-close script marked 38 tickets as resolved without checking whether the SLA window had passed. The sla_breached flag was never set on them.

Tables you'll query

tickets

What you'll learn

SELECT & FilteringDate & Time Functions
Investigate this case →