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,362 | 24.9d | 0.0d | 6.0d | |
| Low | 2 | 4.0d | 7.0d | 7.0d | |
| Standard | 13,685 | 3.3d | 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,420 | 8.2d | 0.0d | 3.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 |
|---|---|---|---|---|---|
| 804 | 99.1d | 111.0d | 79,711d | ||
| 963 | 12.0d | 10.0d | 11,583d | ||
| 1,653 | 6.6d | 0.0d | 10,975d | ||
| 2,669 | 2.6d | 1.0d | 7,006d | ||
| 177 | 14.5d | 12.0d | 2,571d | ||
| 847 | 2.8d | 1.0d | 2,389d | ||
| 1,425 | 1.1d | 0.0d | 1,511d | ||
| 97 | 14.4d | 6.0d | 1,397d | ||
| 1,193 | 1.2d | 0.0d | 1,390d | ||
| 104 | 12.6d | 5.0d | 1,310d | ||
| 1,602 | 0.8d | 0.0d | 1,261d | ||
| 158 | 7.2d | 3.0d | 1,136d | ||
| 37 | 29.9d | 5.0d | 1,105d | ||
| 502 | 2.2d | 0.0d | 1,089d | ||
| 1,289 | 0.6d | 0.0d | 761d |
| Account | Cases | Mean | P50 | P75 | Total Delay | Impact |
|---|---|---|---|---|---|---|
| 5,883 | 18.3d | 1.0d | 8.0d | 107,511d | ||
| 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 | ||
| 39 | 5.9d | 1.0d | 7.0d | 229d | ||
| 6 | 37.8d | 0.0d | 1.0d | 227d | ||
| 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 | ||
| 17 | 7.4d | 0.0d | 0.0d | 125d | ||
| 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 |
| Case # | Subject | Owner | Priority | Status | Days | Created |
|---|---|---|---|---|---|---|
| 00502668 | Standard | Closed | 226 | 2025-06-17 | ||
| 00495534 | Standard | Rejected | 218 | 2025-05-22 | ||
| 00495542 | Standard | Rejected | 218 | 2025-05-22 | ||
| 00495602 | Standard | Rejected | 218 | 2025-05-22 | ||
| 00502145 | Standard | Rejected | 193 | 2025-06-16 | ||
| 00503184 | Standard | Rejected | 191 | 2025-06-18 | ||
| 00503062 | Standard | Rejected | 191 | 2025-06-18 | ||
| 00503650 | Standard | Rejected | 190 | 2025-06-19 | ||
| 00503727 | Standard | Rejected | 189 | 2025-06-20 | ||
| 00507102 | High | Closed | 174 | 2025-07-01 | ||
| 00507113 | High | Closed | 174 | 2025-07-01 | ||
| 00507216 | High | Closed | 174 | 2025-07-01 | ||
| 00507362 | High | Closed | 173 | 2025-07-02 | ||
| 00507363 | High | Closed | 173 | 2025-07-02 | ||
| 00507526 | High | Closed | 173 | 2025-07-02 | ||
| 00507572 | High | Closed | 173 | 2025-07-02 | ||
| 00508360 | Standard | Rejected | 172 | 2025-07-07 | ||
| 00508362 | Standard | Rejected | 172 | 2025-07-07 | ||
| 00507769 | High | Closed | 172 | 2025-07-03 | ||
| 00507839 | High | Closed | 172 | 2025-07-03 |