Statistical analysis of case resolution times — by priority, owner, origin, and account
Box = P25–P75 (IQR) | Line = median | ◯ = mean | Whiskers = min–max (capped at 1.5×IQR)
| Priority | Count | Mean | P50 | P75 | Distribution |
|---|---|---|---|---|---|
| High | 2,789 | 4.0d | 0.0d | 1.0d | |
| Low | 2 | 4.0d | 7.0d | 7.0d | |
| Standard | 13,603 | 2.5d | 0.0d | 2.0d | |
| Medium | 55 | 1.6d | 0.0d | 1.0d | |
| Critical | 139 | 1.0d | 0.0d | 1.0d |
| Origin | Count | Mean | P50 | P75 |
|---|---|---|---|---|
| Created From WO | 188 | 3.8d | 1.0d | 3.0d |
| 14,764 | 3.0d | 0.0d | 2.0d | |
| Phone | 621 | 1.3d | 0.0d | 1.0d |
| Web | 623 | 1.0d | 0.0d | 1.0d |
| Client Form | 391 | 0.0d | 0.0d | 0.0d |
| Owner | Cases | Mean | P50 | Total Delay | Impact |
|---|---|---|---|---|---|
| 957 | 11.5d | 10.0d | 11,042d | ||
| 237 | 33.1d | 41.0d | 7,856d | ||
| 2,668 | 2.6d | 1.0d | 6,949d | ||
| 177 | 14.5d | 12.0d | 2,571d | ||
| 1,589 | 1.2d | 0.0d | 1,882d | ||
| 841 | 2.2d | 1.0d | 1,837d | ||
| 97 | 14.4d | 6.0d | 1,397d | ||
| 1,193 | 1.2d | 0.0d | 1,390d | ||
| 1,424 | 1.0d | 0.0d | 1,386d | ||
| 104 | 12.6d | 5.0d | 1,310d | ||
| 1,602 | 0.8d | 0.0d | 1,261d | ||
| 158 | 7.2d | 3.0d | 1,136d | ||
| 502 | 2.2d | 0.0d | 1,089d | ||
| 1,289 | 0.6d | 0.0d | 761d | ||
| 201 | 3.5d | 2.0d | 701d |
| Account | Cases | Mean | P50 | P75 | Total Delay | Impact |
|---|---|---|---|---|---|---|
| 5,248 | 5.0d | 1.0d | 5.0d | 26,297d | ||
| 823 | 6.3d | 5.0d | 10.0d | 5,173d | ||
| 2,902 | 1.4d | 0.0d | 1.0d | 4,163d | ||
| 2,135 | 0.5d | 0.0d | 1.0d | 1,037d | ||
| 27 | 26.2d | 19.0d | 37.0d | 707d | ||
| 46 | 9.7d | 6.0d | 18.0d | 444d | ||
| 38 | 5.9d | 1.0d | 7.0d | 224d | ||
| 121 | 1.4d | 0.0d | 1.0d | 169d | ||
| 256 | 0.6d | 0.0d | 0.0d | 162d | ||
| 193 | 0.8d | 0.0d | 1.0d | 145d | ||
| 5 | 29.0d | 30.0d | 30.0d | 145d | ||
| 283 | 0.5d | 0.0d | 1.0d | 142d | ||
| 37 | 3.7d | 1.0d | 6.0d | 136d | ||
| 599 | 0.2d | 0.0d | 0.0d | 130d | ||
| 7 | 16.1d | 14.0d | 19.0d | 113d | ||
| 6 | 18.8d | 20.0d | 20.0d | 113d | ||
| 39 | 2.8d | 1.0d | 1.0d | 109d | ||
| 26 | 4.0d | 1.0d | 1.0d | 105d | ||
| 8 | 12.4d | 9.0d | 38.0d | 99d | ||
| 144 | 0.7d | 0.0d | 1.0d | 96d |
| Case # | Subject | Owner | Priority | Status | Days | Created |
|---|---|---|---|---|---|---|
| 00544442 | Standard | Rejected | 87 | 2025-11-17 | ||
| 00537671 | High | Closed | 85 | 2025-10-23 | ||
| 00545817 | Standard | Closed | 75 | 2025-11-21 | ||
| 00547641 | Standard | Rejected | 73 | 2025-12-01 | ||
| 00537299 | High | Closed | 71 | 2025-10-21 | ||
| 00541702 | Standard | Closed | 71 | 2025-11-06 | ||
| 00548448 | Standard | Rejected | 71 | 2025-12-03 | ||
| 00545473 | Standard | Closed | 70 | 2025-11-20 | ||
| 00537364 | High | Closed | 70 | 2025-10-22 | ||
| 00537399 | High | Closed | 70 | 2025-10-22 | ||
| 00537494 | High | Closed | 70 | 2025-10-22 | ||
| 00546759 | Standard | Closed | 70 | 2025-11-25 | ||
| 00548783 | High | Closed | 69 | 2025-12-04 | ||
| 00537824 | High | Closed | 69 | 2025-10-23 | ||
| 00548395 | Standard | Closed | 69 | 2025-12-03 | ||
| 00537856 | High | Closed | 69 | 2025-10-23 | ||
| 00537865 | High | Closed | 69 | 2025-10-23 | ||
| 00537889 | High | Closed | 69 | 2025-10-23 | ||
| 00537899 | High | Closed | 69 | 2025-10-23 | ||
| 00537984 | High | Closed | 69 | 2025-10-23 |