Status Transition History Report

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

↻ Refresh Other Reports Back to Dashboard
128
Unique Transitions
54,761
Total Status Changes
15981
Orders with History
91.4h
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)
Open → In-Process 9,504 5.8h 0.2h 0.0h 240.6h ↑ +53.6h (slower)
Shipped → Closed 9,272 213.6h 126.5h 0.0h 3,576.8h ↑ +162.7h (slower)
In-Process → Submitted 4,786 5.6h 0.1h 0.0h 1,254.3h ↑ +3.3h (slower)
In-Process → Shipped 4,179 11.7h 3.5h 0.0h 144.7h ↑ +8.4h (slower)
Pending → Shipped 3,617 3.1h 0.5h 0.0h 233.4h ↑ +2.8h (slower)
Submitted → Shipped 2,995 144.9h 72.3h 0.0h 2,861.3h ↑ +48.5h (slower)
Delivered → Closed 2,534 45.6h 0.0h 0.0h 2,042.0h ↑ +66.0h (slower)
Picked → Ready to Ship 2,424 17.0h 2.7h 0.0h 2,042.7h → stable
Ready to Ship → Pending 2,283 14.5h 1.6h 0.0h 1,033.4h → stable
Open → Picked 1,928 116.5h 20.3h 0.0h 402.6h ↓ -16.5h (faster)
Shipped → Delivered 1,650 190.5h 94.3h 0.0h 3,267.2h ↓ -54.8h (faster)
Submitted → Picked 1,550 79.9h 1.5h 0.0h 1,846.6h ↑ +37.5h (slower)
Open → Shipped 1,541 57.3h 0.0h 0.0h 298.6h -
Submitted to Customer → Delivered 899 3.5h 0.0h 0.0h 258.3h → stable
Open → Closed 897 0.1h 0.1h 0.0h 0.3h -
Picked → Pending 864 0.3h 0.0h 0.0h 139.1h → stable
Picked → Shipped 404 6.2h 0.4h 0.0h 695.2h → stable
Submitted → Pending 341 58.5h 0.0h 0.0h 2,297.0h ↓ -32.4h (faster)
Request Cancellation → Canceled 312 72.4h 0.5h 0.0h 1,078.5h ↑ +61.1h (slower)
In-Process → Open 281 8.6h 0.3h 0.0h 91.5h ↑ +4.4h (slower)
In-Process → Pending 221 4.0h 0.1h 0.0h 189.5h -
Open → Submitted 217 26.4h 2.2h 0.0h 287.8h -
Submitted → Delivered 152 257.7h 160.6h 0.0h 2,203.1h ↓ -30.2h (faster)
Ready to Ship → Shipped 142 20.8h 1.5h 0.0h 979.4h ↓ -12.5h (faster)
Open → Request Cancellation 138 2.5h 0.0h 0.0h 34.7h → stable
Pending → Picked 137 0.5h 0.0h 0.0h 25.1h ↑ +1.8h (slower)
In-Process → Picked 122 12.0h 0.5h 0.0h 341.8h ↓ -1.1h (faster)
Open → Canceled 109 131.4h 20.9h 0.0h 503.8h -
Open → Pending 104 0.0h 0.0h 0.0h 0.0h -
Submitted → Request Cancellation 95 442.9h 218.5h 0.0h 3,331.9h ↑ +606.6h (slower)
Shipped → Submitted 74 131.3h 25.8h 0.0h 1,082.2h ↓ -143.5h (faster)
Delivered → Submitted 68 45.6h 0.0h 0.0h 570.5h -
Shipped → Request Cancellation 54 269.0h 294.3h 0.0h 2,022.6h ↓ -151.3h (faster)
Submitted to Customer → Request Cancellation 51 18.7h 18.7h 18.7h 18.7h -
Shipped → In-Process 40 162.8h 24.0h 0.0h 1,202.5h ↑ +58.3h (slower)
Submitted → In-Process 39 73.3h 3.8h 0.0h 671.8h ↑ +59.9h (slower)
Received → Closed 39 37.6h 0.0h 0.0h 544.1h ↑ +94.1h (slower)
In-Process → Request Cancellation 35 81.5h 18.6h 0.0h 1,361.1h ↑ +3.0h (slower)
Shipped → Received 32 59.8h 25.8h 0.0h 308.9h ↑ +7.5h (slower)
Request Cancellation → Shipped 31 114.5h 62.2h 0.0h 347.5h ↑ +21.1h (slower)
Picked → Submitted 31 0.3h 0.0h 0.0h 6.6h → stable
Pending → In-Process 30 1.5h 1.5h 0.0h 16.4h ↓ -1.6h (faster)
Request Cancellation → Closed 28 140.7h 73.4h 2.5h 1,002.4h ↓ -41.9h (faster)
Submitted → Closed 28 247.9h 121.7h 0.0h 2,331.7h ↑ +871.7h (slower)
Request Cancellation → Delivered 25 114.9h 28.7h 0.0h 386.6h -
Closed → Shipped 24 94.4h 0.0h 0.0h 1,612.9h ↑ +402.7h (slower)
In-Process → Canceled 19 4.1h 0.0h 0.0h 54.0h → stable
Pending → Ready to Ship 19 2.5h 0.1h 0.0h 23.5h → stable
Delivered → Shipped 16 6.4h 1.1h 0.0h 27.6h → stable
Pending → Submitted 16 14.2h 0.2h 0.0h 194.7h ↓ -44.3h (faster)
Shipped → Pending 15 32.7h 4.2h 0.0h 217.9h ↑ +18.4h (slower)
Ready to Ship → In-Process 15 19.2h 0.9h 0.2h 212.8h -
Shipped → Canceled 12 279.1h 68.5h 0.0h 1,484.1h ↓ -560.9h (faster)
Picked → In-Process 12 0.6h 0.1h 0.0h 2.4h -
Picked → Request Cancellation 12 175.2h 47.7h 0.0h 1,398.0h -
Delivered → Request Cancellation 11 97.6h 22.2h 0.0h 506.5h ↑ +256.4h (slower)
Open → Ready to Ship 11 372.1h 744.1h 0.1h 744.1h -
Submitted to Customer → Open 10 - - - - -
Request Cancellation → Submitted 10 83.0h 95.4h 3.8h 218.5h -
Ready to Ship → Request Cancellation 10 91.2h 2.4h 0.0h 835.5h -
Submitted → Canceled 9 221.0h 1.6h 0.7h 1,009.8h -
Picked → Open 9 1.2h 0.2h 0.0h 7.4h → stable
Closed → Open 9 163.4h 1.1h 0.0h 768.1h → stable
In-Process → Ready to Pick 9 0.1h 0.1h 0.0h 0.1h -
Submitted to Customer → In-Process 9 - - - - -
Canceled → Open 9 16.0h 0.3h 0.0h 142.0h -
Submitted to Customer → Picked 9 - - - - -
Closed → Canceled 8 389.9h 0.0h 0.0h 1,631.8h ↓ -1,395.9h (faster)
Closed → Submitted 8 243.1h 55.7h 0.0h 839.1h ↑ +811.0h (slower)
Submitted → Received 8 124.8h 71.9h 24.4h 475.1h ↓ -407.2h (faster)
Submitted → Ready to Pick 8 0.0h 0.0h 0.0h 0.0h -
Shipped → Open 7 692.5h 367.1h 1.6h 3,217.0h -
Open → Ready to Pick 7 - - - - -
Ready to Pick → Picked 7 140.5h 21.5h 19.6h 782.0h ↑ +761.4h (slower)
Open → Delivered 6 23.1h 23.1h 23.1h 23.1h -
Ready to Pick → In-Process 6 116.7h 60.9h 0.0h 529.0h -
Submitted → Open 6 21.0h 0.8h 0.0h 100.5h -
Submitted to Customer → Closed 6 - - - - -
Canceled → In-Process 5 138.0h 0.0h 0.0h 526.3h → stable
Submitted to Customer → Shipped 5 - - - - -
Ready to Pick → Submitted 5 3.5h 4.3h 0.0h 4.6h -
Pending → Closed 5 66.7h 25.3h 4.4h 164.0h ↓ -16.3h (faster)
Ready to Pick → Shipped 5 43.2h 41.4h 40.8h 46.5h -
Ready to Ship → Open 4 31.7h 3.4h 0.0h 120.1h -
Pending → Request Cancellation 4 2.0h 1.6h 0.2h 6.1h -
Closed → Pending 4 93.0h 170.6h 0.1h 186.4h -
Received → Delivered 4 0.0h 0.0h 0.0h 0.0h → stable
Request Cancellation → In-Process 4 33.3h 62.9h 0.0h 65.5h ↑ +61.7h (slower)
Request Cancellation → Open 3 66.4h 5.2h 1.5h 192.5h -
In-Process → Ready to Ship 3 16.1h 0.4h 0.1h 47.8h -
Submitted → Ready to Ship 3 0.0h 0.0h 0.0h 0.0h -
Ready to Ship → Picked 3 20.5h 2.6h 0.0h 58.9h -
In-Process → Delivered 3 666.5h 811.2h 0.1h 1,188.2h -
Submitted to Customer → Canceled 3 - - - - -
Closed → Delivered 2 478.0h 838.7h 117.3h 838.7h -
Pending → Open 2 0.2h 0.4h 0.1h 0.4h -
Shipped → Picked 2 63.9h 126.6h 1.3h 126.6h -
Ready to Ship → Closed 2 2.7h 5.3h 0.2h 5.3h -
Canceled → Submitted 2 181.5h 362.9h 0.1h 362.9h -
Canceled → Closed 2 155.3h 310.5h 0.0h 310.5h -
Ready to Ship → Submitted 2 9.3h 17.8h 0.8h 17.8h -
Closed → In-Process 2 290.9h 530.7h 51.2h 530.7h -
In-Process → Closed 2 1.4h 2.7h 0.0h 2.7h -
Ready to Ship → Canceled 1 - - - - -
Submitted to Customer → Pending 1 - - - - -
Submitted to Customer → Submitted 1 - - - - -
Ready to Ship → Ready to Pick 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 -
Closed → Picked 1 4.0h 4.0h 4.0h 4.0h -
Shipped → Ready to Ship 1 88.5h 88.5h 88.5h 88.5h -
Picked → Canceled 1 0.2h 0.2h 0.2h 0.2h -
Request Cancellation → Received 1 4.2h 4.2h 4.2h 4.2h -
Open → Received 1 - - - - -
Delivered → Ready to Ship 1 1.3h 1.3h 1.3h 1.3h -
Submitted → Submitted to Customer 1 0.0h 0.0h 0.0h 0.0h -
Delivered → Picked 1 3.5h 3.5h 3.5h 3.5h -
Canceled → Shipped 1 951.2h 951.2h 951.2h 951.2h -
Delivered → Open 1 120.0h 120.0h 120.0h 120.0h -
Submitted to Customer → Received 1 - - - - -
In-Process → Submitted to Customer 1 0.0h 0.0h 0.0h 0.0h -
Ready to Pick → Pending 1 58.8h 58.8h 58.8h 58.8h -
Delivered → Pending 1 1.1h 1.1h 1.1h 1.1h -
Open → Submitted to Customer 1 - - - - -
Ready to Pick → Open 1 35.6h 35.6h 35.6h 35.6h -
Canceled → Request Cancellation 1 0.0h 0.0h 0.0h 0.0h -
Open → Lead Time 1 0.1h 0.1h 0.1h 0.1h -
Lead Time → In-Process 1 0.0h 0.0h 0.0h 0.0h -

Monthly Breakdown (status changes per month)

Month Open → In-Process Shipped → Closed In-Process → Submitted In-Process → Shipped Pending → Shipped Submitted → Shipped Delivered → Closed Picked → Ready to Ship
Oct 2026 7 1221 679 65 362 488 377 275
Sep 2026 221 2368 869 2237 566 608 537 393
Aug 2026 37 2274 1100 1368 661 697 432 409
Jul 2026 4 934 690 346 756 325 274 409
Jun 2026 4 986 656 30 655 363 347 431
May 2026 2 744 575 75 438 285 310 359