Status Transition History Report

Historical analysis of time between parts order status changes Cached 7:47pm

↻ Refresh Other Reports Back to Dashboard
119
Unique Transitions
44,328
Total Status Changes
12769
Orders with History
84.6h
Avg Time per Transition

Monthly Trend - Average Hours Between Status Changes (Top 5 Transitions)

Status Transition Analysis (sorted by frequency)

Transition Count Avg Hours Median Hours Min Max Trend (Last 3 Months)
Shipped → Closed 7,100 167.6h 93.3h 0.0h 4,098.4h ↑ +113.2h (slower)
Open → In-Process 6,030 65.8h 0.1h 0.0h 1,460.2h ↓ -293.2h (faster)
In-Process → Submitted 4,166 5.3h 0.1h 0.0h 1,254.3h → stable
Pending → Shipped 4,073 2.4h 0.5h 0.0h 233.4h → stable
Submitted → Shipped 2,666 163.2h 72.1h 0.0h 3,162.1h ↓ -132.4h (faster)
Picked → Ready to Ship 2,581 12.5h 2.0h 0.0h 675.4h ↓ -3.9h (faster)
Ready to Ship → Pending 2,435 11.6h 1.4h 0.0h 478.7h → stable
Delivered → Closed 2,061 37.5h 0.0h 0.0h 2,868.0h ↓ -19.8h (faster)
Open → Picked 2,015 85.1h 18.4h 0.0h 402.6h ↑ +147.6h (slower)
Open → Shipped 1,404 74.9h 5.3h 0.0h 298.6h -
Submitted → Picked 1,249 83.4h 1.5h 0.0h 2,012.8h ↓ -40.9h (faster)
In-Process → Shipped 1,211 5.1h 0.8h 0.0h 239.8h ↓ -2.3h (faster)
Shipped → Delivered 1,166 230.4h 141.1h 0.0h 3,221.1h ↓ -28.8h (faster)
Open → Closed 905 308.5h 0.3h 0.0h 2,440.6h -
Submitted to Customer → Delivered 787 0.0h 0.0h 0.0h 0.0h → stable
In-Process → Pending 665 1.7h 0.0h 0.0h 189.5h → stable
Picked → Pending 518 0.7h 0.0h 0.0h 139.1h → stable
Submitted → Pending 425 57.8h 0.0h 0.0h 2,634.9h ↓ -32.1h (faster)
Request Cancellation → Canceled 326 71.0h 0.2h 0.0h 2,011.1h ↓ -131.9h (faster)
Picked → Shipped 260 8.5h 0.5h 0.0h 695.2h ↓ -30.7h (faster)
Open → Submitted 215 280.1h 1.0h 0.0h 1,827.9h -
Open → Pending 181 - - - - -
Open → Request Cancellation 174 81.6h 0.0h 0.0h 840.5h -
Ready to Ship → Shipped 148 10.4h 1.3h 0.0h 216.3h ↑ +2.3h (slower)
Open → Canceled 116 131.2h 20.9h 0.0h 503.8h -
Submitted → Delivered 105 374.0h 212.2h 0.0h 2,206.8h ↓ -89.0h (faster)
Submitted → Request Cancellation 94 436.6h 191.9h 0.0h 3,710.1h ↑ +1,531.9h (slower)
In-Process → Picked 73 15.1h 0.4h 0.0h 341.8h ↑ +15.0h (slower)
Pending → Picked 69 0.3h 0.0h 0.0h 6.2h → stable
Pending → In-Process 60 1.7h 1.5h 0.0h 16.4h ↑ +2.1h (slower)
Delivered → Shipped 56 51.9h 0.0h 0.0h 821.0h -
Shipped → Submitted 55 246.2h 49.9h 0.0h 1,774.8h ↑ +58.8h (slower)
Shipped → Request Cancellation 50 328.8h 95.1h 0.0h 2,916.9h ↓ -961.0h (faster)
In-Process → Open 49 3.8h 0.1h 0.0h 72.4h -
Submitted to Customer → Request Cancellation 44 - - - - -
Received → Closed 40 29.8h 0.0h 0.0h 544.1h → stable
Submitted → Closed 40 181.4h 116.7h 0.0h 2,013.1h ↑ +11.3h (slower)
Shipped → In-Process 35 458.6h 24.1h 0.0h 2,103.9h ↓ -401.5h (faster)
Ready to Ship → In-Process 34 15.1h 0.9h 0.0h 212.8h -
Picked → Submitted 33 1.9h 0.0h 0.0h 51.9h → stable
Request Cancellation → Shipped 32 128.1h 43.8h 0.0h 529.5h ↓ -1.7h (faster)
Pending → Ready to Ship 31 3.9h 0.0h 0.0h 24.3h ↓ -20.7h (faster)
Shipped → Pending 30 23.8h 1.5h 0.0h 217.9h ↓ -31.4h (faster)
Shipped → Received 30 52.0h 24.0h 0.0h 308.9h ↑ +42.0h (slower)
In-Process → Request Cancellation 26 148.5h 4.1h 0.0h 1,704.9h ↓ -343.2h (faster)
Submitted → In-Process 25 32.8h 0.6h 0.0h 336.0h → stable
Closed → Shipped 24 52.8h 0.0h 0.0h 480.7h ↓ -31.4h (faster)
Submitted to Customer → Open 24 - - - - -
Open → Ready to Ship 20 271.0h 113.4h 113.3h 744.1h -
Request Cancellation → Delivered 19 64.0h 19.2h 0.0h 433.1h -
In-Process → Canceled 19 6.5h 0.1h 0.0h 70.0h → stable
Request Cancellation → Closed 18 191.6h 96.5h 0.0h 1,002.4h ↑ +97.9h (slower)
Picked → In-Process 17 14.6h 0.1h 0.0h 239.0h → stable
Submitted → Canceled 16 426.6h 136.5h 1.5h 1,770.1h -
Pending → Submitted 15 13.5h 0.0h 0.0h 194.7h ↑ +65.5h (slower)
Shipped → Canceled 14 539.6h 242.3h 0.0h 2,284.9h ↑ +717.1h (slower)
Closed → Open 13 109.7h 4.7h 0.0h 768.1h ↓ -767.9h (faster)
Closed → Submitted 11 171.6h 77.8h 0.0h 556.1h -
Ready to Ship → Request Cancellation 11 35.5h 2.4h 0.0h 232.4h -
Submitted to Customer → Canceled 10 - - - - -
Picked → Request Cancellation 10 70.8h 30.0h 0.5h 267.3h -
Submitted → Open 9 27.5h 3.4h 0.0h 146.9h -
Submitted → Received 9 137.2h 71.9h 24.4h 618.6h -
In-Process → Ready to Ship 8 8.2h 0.6h 0.1h 47.8h -
Submitted to Customer → Picked 8 - - - - -
Picked → Open 8 1.0h 0.1h 0.0h 7.4h ↓ -7.3h (faster)
Shipped → Open 7 129.3h 106.2h 0.0h 367.1h -
Shipped → Picked 7 50.6h 4.8h 0.0h 168.5h -
Submitted to Customer → In-Process 7 - - - - -
Closed → Canceled 6 0.1h 0.0h 0.0h 0.5h -
Request Cancellation → Submitted 6 67.4h 47.6h 1.8h 219.9h -
Canceled → Open 6 98.2h 19.3h 0.0h 427.2h -
Closed → Pending 5 42.7h 0.2h 0.0h 170.6h -
Pending → Closed 5 61.6h 19.9h 0.0h 164.0h -
Closed → Delivered 5 168.0h 0.0h 0.0h 838.7h -
Request Cancellation → Open 5 117.1h 163.3h 0.1h 227.7h -
Pending → Request Cancellation 5 2.5h 1.6h 0.3h 6.1h -
Submitted to Customer → Submitted 5 316.6h 316.6h 316.6h 316.6h -
Submitted to Customer → Shipped 5 - - - - -
Ready to Pick → Submitted 5 3.5h 4.3h 0.0h 4.6h -
Submitted → Ready to Ship 4 0.0h 0.0h 0.0h 0.1h → stable
In-Process → Closed 4 18.7h 2.7h 0.0h 70.1h -
Request Cancellation → In-Process 4 10.6h 20.2h 0.0h 22.3h -
Ready to Ship → Open 4 31.8h 3.4h 0.3h 120.1h -
Canceled → In-Process 4 41.0h 0.0h 0.0h 163.9h -
In-Process → Ready to Pick 4 0.0h 0.1h 0.0h 0.1h -
Open → Delivered 3 0.0h 0.0h 0.0h 0.0h -
Closed → In-Process 3 305.3h 174.8h 51.2h 689.8h -
Ready to Ship → Picked 3 0.9h 0.1h 0.0h 2.6h -
Delivered → Request Cancellation 3 376.7h 145.4h 1.0h 983.8h -
Ready to Ship → Submitted 3 1.3h 0.8h 0.0h 3.2h -
Closed → Picked 2 41.0h 78.1h 4.0h 78.1h -
Canceled → Submitted 2 106.3h 212.6h 0.1h 212.6h -
Delivered → Submitted 2 85.4h 170.7h 0.0h 170.7h -
Received → Shipped 2 95.3h 190.6h 0.0h 190.6h -
Submitted to Customer → Pending 2 - - - - -
Pending → Open 2 0.7h 1.0h 0.4h 1.0h -
Shipped → Ready to Ship 2 127.2h 166.0h 88.5h 166.0h -
In-Process → Delivered 2 0.0h 0.1h 0.0h 0.1h -
Picked → Canceled 2 11.3h 22.3h 0.2h 22.3h -
Ready to Ship → Closed 2 2.7h 5.3h 0.2h 5.3h -
Submitted to Customer → Closed 2 - - - - -
Ready to Ship → Canceled 1 - - - - -
Picked → Delivered 1 0.0h 0.0h 0.0h 0.0h -
Delivered → Pending 1 0.1h 0.1h 0.1h 0.1h -
Canceled → Delivered 1 0.0h 0.0h 0.0h 0.0h -
Closed → Received 1 0.0h 0.0h 0.0h 0.0h -
Pending → Delivered 1 0.0h 0.0h 0.0h 0.0h -
Delivered → Received 1 0.0h 0.0h 0.0h 0.0h -
Closed → Submitted to Customer 1 0.0h 0.0h 0.0h 0.0h -
Canceled → Request Cancellation 1 0.1h 0.1h 0.1h 0.1h -
Open → Ready to Pick 1 - - - - -
Ready to Pick → In-Process 1 0.0h 0.0h 0.0h 0.0h -
Ready to Ship → Ready to Pick 1 0.0h 0.0h 0.0h 0.0h -
Canceled → Closed 1 0.0h 0.0h 0.0h 0.0h -
Closed → Ready to Ship 1 0.0h 0.0h 0.0h 0.0h -
Delivered → In-Process 1 0.2h 0.2h 0.2h 0.2h -
Received → Delivered 1 0.0h 0.0h 0.0h 0.0h -
Open → Received 1 - - - - -

Monthly Breakdown (status changes per month)

Month Shipped → Closed Open → In-Process In-Process → Submitted Pending → Shipped Submitted → Shipped Picked → Ready to Ship Ready to Ship → Pending Delivered → Closed
Aug 2026 867 34 542 336 377 197 198 145
Jul 2026 946 4 690 756 328 409 401 290
Jun 2026 1007 5 656 655 371 431 418 344
May 2026 793 3 575 438 327 359 308 312
Apr 2026 1201 7 611 500 438 434 387 280
Mar 2026 1500 2 751 1057 466 521 502 307