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 | 3,128 | 15.2d | 0.0d | 2.0d | |
| Low | 2 | 4.0d | 7.0d | 7.0d | |
| Standard | 13,653 | 2.9d | 0.0d | 2.0d | |
| Critical | 140 | 1.6d | 0.0d | 1.0d | |
| Medium | 55 | 1.6d | 0.0d | 1.0d |
| Origin | Count | Mean | P50 | P75 |
|---|---|---|---|---|
| 15,154 | 5.6d | 0.0d | 2.0d | |
| Created From WO | 188 | 3.8d | 1.0d | 3.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 |
|---|---|---|---|---|---|
| 572 | 76.7d | 83.0d | 43,853d | ||
| 962 | 11.9d | 10.0d | 11,415d | ||
| 2,669 | 2.6d | 1.0d | 7,006d | ||
| 1,625 | 3.7d | 0.0d | 6,090d | ||
| 177 | 14.5d | 12.0d | 2,571d | ||
| 847 | 2.8d | 1.0d | 2,389d | ||
| 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 | ||
| 33 | 32.9d | 6.0d | 1,087d | ||
| 1,289 | 0.6d | 0.0d | 761d |
| Account | Cases | Mean | P50 | P75 | Total Delay | Impact |
|---|---|---|---|---|---|---|
| 5,623 | 11.9d | 1.0d | 7.0d | 66,826d | ||
| 823 | 6.3d | 5.0d | 10.0d | 5,173d | ||
| 2,904 | 1.5d | 0.0d | 1.0d | 4,349d | ||
| 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 | ||
| 194 | 0.8d | 0.0d | 1.0d | 147d | ||
| 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 | ||
| 15 | 7.4d | 1.0d | 5.0d | 111d | ||
| 39 | 2.8d | 1.0d | 1.0d | 109d | ||
| 26 | 4.0d | 1.0d | 1.0d | 105d | ||
| 8 | 12.4d | 9.0d | 38.0d | 99d |
| Case # | Subject | Owner | Priority | Status | Days | Created |
|---|---|---|---|---|---|---|
| 00518755 | High | Closed | 135 | 2025-08-13 | ||
| 00518873 | High | Closed | 135 | 2025-08-13 | ||
| 00519019 | High | Closed | 134 | 2025-08-14 | ||
| 00519025 | High | Closed | 134 | 2025-08-14 | ||
| 00519027 | High | Closed | 134 | 2025-08-14 | ||
| 00519034 | High | Closed | 134 | 2025-08-14 | ||
| 00519233 | High | Closed | 134 | 2025-08-14 | ||
| 00519375 | High | Closed | 133 | 2025-08-15 | ||
| 00519380 | High | Closed | 133 | 2025-08-15 | ||
| 00519392 | High | Closed | 133 | 2025-08-15 | ||
| 00519416 | High | Closed | 133 | 2025-08-15 | ||
| 00519513 | High | Closed | 133 | 2025-08-15 | ||
| 00519534 | High | Closed | 133 | 2025-08-15 | ||
| 00521047 | High | Closed | 131 | 2025-08-21 | ||
| 00521097 | High | Closed | 131 | 2025-08-21 | ||
| 00521099 | High | Closed | 131 | 2025-08-21 | ||
| 00521104 | High | Closed | 131 | 2025-08-21 | ||
| 00519820 | High | Closed | 130 | 2025-08-18 | ||
| 00519826 | High | Closed | 130 | 2025-08-18 | ||
| 00519831 | High | Closed | 130 | 2025-08-18 |