61 service requests

About this visual

Each circle represents a possible state of the service request.

The size represents the percentage of time spent by all service requests in this state. (Larger circles indicate more time.)

The colour represents the time spent by any service requests, on average in this state. (Red circles indicate a higher average processing time.)

The arcs on top represent forward flows, from left to right. Their size and colour again represent the total and average time spent in that transition.

The arcs below represent reverse flows, from right to left. Their size and colour are similarly constructed.

4.7% Cancelled 2.7% Closed 23.4% Completed 0.0% Draft 28.2% In Progress 2.8% Pending 25.9% Planning 0.0% Rejected 0.0% Submitted 12.2% Waiting Approval

Cause of delay This visual uses Group-Means: a Gramener algorithm

Group Count Days spent

* Empty cell implies no impact

Summary of the causes

There are no significant causes of delay that we can infer for this segment from the data.

Service requests status Showing 100 out of 232

Service Request ID SR Audit Create Datetime SR Audit Status Next status Time spent
REQ000000646355 10-09-14 10:02 Planning In Progress 16720
REQ000000646355 10-09-14 14:40 In Progress Closed 8476865
REQ000000646355 10-09-14 9:37 Submitted Waiting Approval 9
REQ000000646355 10-09-14 9:37 Waiting Approval Planning 1466
REQ000000646355 12-02-14 10:03 Completed Submitted 18142446
REQ000000646712 10-09-14 12:26 Planning In Progress 2441
REQ000000646712 10-09-14 13:07 In Progress Closed 8482466
REQ000000646712 10-09-14 9:52 Submitted Waiting Approval 11
REQ000000646712 10-09-14 9:52 Waiting Approval Planning 9262
REQ000000646712 12-02-14 10:03 Completed Submitted 18143303
REQ000000661616 11-03-14 16:45 Planning Pending 7924299
REQ000000661616 11-06-14 9:57 Pending Submitted 10726312
REQ000000661616 12-02-14 16:06 In Progress Planning 2335143
REQ000000661616 13-10-14 13:29 Submitted Waiting Approval 11
REQ000000680751 11-03-14 23:11 In Progress Completed 35988
REQ000000680751 11-03-14 8:44 Planning In Progress 51976
REQ000000680751 12-03-14 9:10 Completed Submitted 18849001
REQ000000680751 16-10-14 13:00 Submitted Waiting Approval 11
REQ000000680751 16-10-14 13:01 Waiting Approval Closed 5459139
REQ000000680925 16-10-14 13:14 Submitted Waiting Approval 11
REQ000000680925 16-10-14 13:14 Waiting Approval Planning 7398
REQ000000680925 16-10-14 15:17 Planning Cancelled 3092703
REQ000000681424 11-03-14 8:44 Planning Completed 87896
REQ000000681424 11-04-14 15:34 In Progress Submitted 16239270
REQ000000681424 12-03-14 9:09 Completed In Progress 2615092
REQ000000681424 16-10-14 14:29 Submitted Waiting Approval 15
REQ000000681424 16-10-14 14:29 Waiting Approval Closed 5453830
REQ000000681656 12-03-14 8:36 Completed Submitted 18857004
REQ000000681656 16-10-14 14:39 Submitted Waiting Approval 12
REQ000000681656 16-10-14 14:40 Waiting Approval Planning 3853
REQ000000681656 16-10-14 15:44 Planning In Progress 333468
REQ000000681656 20-10-14 12:22 In Progress Closed 5115875
REQ000000716984 11-06-14 9:39 In Progress Submitted 11657291
REQ000000716984 24-10-14 7:47 Submitted Waiting Approval 11
REQ000000716984 24-10-14 7:47 Waiting Approval Planning 517477
REQ000000717764 17-11-14 11:47 In Progress Pending 2081868
REQ000000717764 24-10-14 9:30 Submitted Waiting Approval 8
REQ000000717764 24-10-14 9:31 Waiting Approval Planning 511294
REQ000000717764 30-10-14 7:32 Planning In Progress 1570494
REQ000000718357 11-03-14 8:47 Planning In Progress 2702652
REQ000000718357 11-04-14 15:32 In Progress Submitted 16919253
REQ000000718357 24-10-14 11:19 Submitted Waiting Approval 8
REQ000000718369 11-03-14 8:48 Planning Submitted 19622776
REQ000000718369 24-10-14 11:34 Submitted Waiting Approval 8
REQ000000718369 24-10-14 11:34 Waiting Approval In Progress 4152686
REQ000000718466 11-03-14 8:48 Planning Submitted 19623074
REQ000000718466 24-10-14 11:39 Submitted Waiting Approval 8
REQ000000718466 24-10-14 11:39 Waiting Approval In Progress 2930786
REQ000000722799 11-06-14 9:26 Pending Submitted 11912457
REQ000000722799 12-01-14 8:45 In Progress Pending 12962421
REQ000000722799 27-10-14 6:27 Submitted Waiting Approval 9
REQ000000722799 27-10-14 6:27 Waiting Approval Planning 265166
REQ000000723392 19-11-14 9:57 In Progress Pending 1901065
REQ000000723392 27-10-14 10:26 Planning In Progress 1985457
REQ000000723392 27-10-14 7:33 Submitted Waiting Approval 9
REQ000000723392 27-10-14 7:33 Waiting Approval Planning 10381
REQ000000723395 19-11-14 10:26 In Progress Pending 1899453
REQ000000723395 27-10-14 10:26 Planning In Progress 1987179
REQ000000723395 27-10-14 7:37 Submitted Waiting Approval 12
REQ000000723395 27-10-14 7:37 Waiting Approval Planning 10141
REQ000000723474 11-12-14 10:04 In Progress Pending 19980
REQ000000723474 19-11-14 10:32 In Progress In Progress 1899161
REQ000000723474 27-10-14 10:29 Planning In Progress 1987352
REQ000000723474 27-10-14 7:35 Submitted Waiting Approval 11
REQ000000723474 27-10-14 7:35 Waiting Approval Planning 10435
REQ000000723519 11-06-14 9:36 In Progress Submitted 11913887
REQ000000723519 27-10-14 7:01 Submitted Waiting Approval 7
REQ000000723519 27-10-14 7:01 Waiting Approval Planning 10639
REQ000000723730 19-11-14 10:09 In Progress Pending 1900396
REQ000000723730 27-10-14 10:26 Planning In Progress 1986193
REQ000000723730 27-10-14 7:39 Submitted Waiting Approval 11
REQ000000723730 27-10-14 7:39 Waiting Approval Planning 10020
REQ000000723754 11-03-14 15:37 Planning In Progress 10511799
REQ000000723754 11-07-14 7:34 In Progress Submitted 9333262
REQ000000723754 27-10-14 8:08 Submitted Waiting Approval 32
REQ000000724768 27-10-14 10:06 Submitted Waiting Approval 27
REQ000000724768 27-10-14 10:06 Waiting Approval Planning 82504
REQ000000724768 28-10-14 9:01 Planning In Progress 276866
REQ000000725418 27-10-14 10:35 Submitted Waiting Approval 28
REQ000000725418 27-10-14 10:35 Waiting Approval Planning 19782
REQ000000725418 27-10-14 16:05 Planning In Progress 338519
REQ000000725631 27-10-14 10:58 Submitted Waiting Approval 13
REQ000000725631 27-10-14 10:59 Waiting Approval Planning 246703
REQ000000725631 30-10-14 7:30 Planning In Progress 3650079
REQ000000726194 11-11-14 7:50 Planning In Progress 2592420
REQ000000726194 11-12-14 7:57 In Progress Completed 4669369
REQ000000726194 27-10-14 13:25 Draft Submitted 350875
REQ000000726194 31-10-14 14:52 Submitted Waiting Approval 12
REQ000000726194 31-10-14 14:53 Waiting Approval Planning 925038
REQ000000726590 24-11-14 11:48 In Progress Pending 1474304
REQ000000726590 27-10-14 13:58 Submitted Waiting Approval 12
REQ000000726590 27-10-14 13:59 Waiting Approval Planning 236066
REQ000000726590 30-10-14 7:33 Planning In Progress 2175300
REQ000000726748 11-04-14 7:43 Planning Submitted 17215647
REQ000000726748 24-11-14 12:03 In Progress Pending 1471993
REQ000000726748 27-10-14 13:51 Submitted Waiting Approval 12
REQ000000726748 27-10-14 13:51 Waiting Approval In Progress 2412724
REQ000000726995 27-10-14 14:33 Submitted Waiting Approval 15
REQ000000726995 27-10-14 14:33 Waiting Approval Planning 258950
REQ000000726995 30-10-14 14:29 Planning In Progress 4509

Process Workflow Optimization

This page shows all required calculations for the workflow POC.

Computations

  1. De-duplicate data by primary keys Service Request ID, SR Audit Create Datetime, and SR Audit Status.
  2. Sort by Service Request ID, and within that, by SR Audit Create Datetime.
  3. Add a Next status column that has the next row's SR Audit Status within a given Service Request ID. (The last row in each Service Request ID will have a NaN Next status.)
  4. Calculate the Time spent as the next row's SR Audit Create Datetime minus the current row's SR Audit Create Datetime. For the last row, this value will be NaN.

Basic statistics

Time spent in each status, on average

count count_transitioned mean_days total_days
Cancelled 2 2 221.2 442.3
Closed 2 2 130.4 260.9
Completed 12 12 185.8 2,229.1
Draft 2 2 2.0 4.1
In Progress 37 37 72.5 2,682.3
Pending 2 2 131.0 262.0
Planning 56 56 44.0 2,464.6
Rejected 1 1 0.0 0.0
Submitted 62 62 0.0 0.0
Waiting Approval 56 56 20.7 1,161.0

Time spent on transitions

count mean_days total_days
SR Audit Status Next status
Cancelled Planning 1 213.1 213.1
Submitted 1 229.2 229.2
Closed Completed 2 130.4 260.9
Completed Closed 1 15.0 15.0
In Progress 1 30.3 30.3
Planning 3 213.2 639.5
Submitted 7 220.6 1,544.3
Draft Submitted 2 2.0 4.1
In Progress Cancelled 1 14.0 14.0
Closed 8 65.1 520.9
Completed 3 18.2 54.5
In Progress 1 22.0 22.0
Pending 11 70.5 775.1
Planning 3 66.6 199.8
Submitted 10 109.6 1,096.1
Pending Submitted 2 131.0 262.0
Planning Cancelled 1 35.8 35.8
Completed 1 1.0 1.0
In Progress 45 25.6 1,151.4
Pending 1 91.7 91.7
Submitted 8 148.1 1,184.6
Rejected Draft 1 0.0 0.0
Submitted Waiting Approval 62 0.0 0.0
Waiting Approval Closed 5 54.9 274.7
In Progress 9 32.1 289.0
Planning 41 14.6 597.3
Rejected 1 0.0 0.0