27 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.

10.7% Closed 54.5% Completed 14.0% In Progress 12.0% Planning 0.0% Submitted 8.8% 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 100

Service Request ID SR Audit Create Datetime SR Audit Status Next status Time spent
REQ000000648239 10-09-14 14:12 Submitted Waiting Approval 14
REQ000000648239 10-09-14 14:12 Waiting Approval Planning 3094472
REQ000000648239 16-10-14 9:47 Planning In Progress 82707
REQ000000839484 12-03-14 10:48 Completed Submitted 21782827
REQ000000839484 19-11-14 13:35 Submitted Waiting Approval 17
REQ000000839484 19-11-14 13:36 Waiting Approval Planning 18415
REQ000000839484 19-11-14 18:43 Planning In Progress 56589
REQ000000839484 20-11-14 10:26 In Progress Closed 2444401
REQ000000839584 19-11-14 13:59 Submitted Waiting Approval 15
REQ000000839584 19-11-14 14:00 Waiting Approval Planning 16959
REQ000000839584 19-11-14 18:42 Planning In Progress 56876
REQ000000839584 20-11-14 10:30 In Progress Closed 5421487
REQ000000839584 22-01-15 4:28 Closed Completed 11270424
REQ000000839778 12-03-14 10:52 Completed Submitted 21784209
REQ000000839778 19-11-14 14:02 Submitted Waiting Approval 27
REQ000000839778 19-11-14 14:02 Waiting Approval Planning 16829
REQ000000839778 19-11-14 18:43 Planning In Progress 57283
REQ000000839778 20-11-14 10:38 In Progress Closed 2443695
REQ000000839950 12-03-14 10:49 Completed Submitted 21784587
REQ000000839950 19-11-14 14:05 Submitted Waiting Approval 18
REQ000000839950 19-11-14 14:05 Waiting Approval Planning 16614
REQ000000839950 19-11-14 18:42 Planning In Progress 57888
REQ000000839950 20-11-14 10:47 In Progress Closed 2443120
REQ000000839957 12-03-14 10:47 Completed Submitted 21785150
REQ000000839957 19-11-14 14:13 Submitted Waiting Approval 17
REQ000000839957 19-11-14 14:13 Waiting Approval Planning 16145
REQ000000839957 19-11-14 18:42 Planning In Progress 66564
REQ000000839957 20-11-14 13:12 In Progress Closed 2434456
REQ000000840036 12-03-14 10:50 Completed Submitted 21784711
REQ000000840036 19-11-14 14:09 Submitted Waiting Approval 20
REQ000000840036 19-11-14 14:09 Waiting Approval Planning 16394
REQ000000840036 19-11-14 18:42 Planning In Progress 65101
REQ000000840036 20-11-14 12:47 In Progress Closed 2435920
REQ000000840133 12-03-14 10:47 Completed Submitted 21784606
REQ000000840133 19-11-14 14:03 Submitted Waiting Approval 22
REQ000000840133 19-11-14 14:04 Waiting Approval Planning 16693
REQ000000840133 19-11-14 18:42 Planning In Progress 57545
REQ000000840133 20-11-14 10:41 In Progress Closed 2443485
REQ000000840215 19-11-14 14:07 Submitted Waiting Approval 14
REQ000000840215 19-11-14 14:07 Waiting Approval Planning 16536
REQ000000840215 19-11-14 18:43 Planning In Progress 58128
REQ000000840215 20-11-14 10:52 In Progress Closed 5420195
REQ000000840215 22-01-15 4:28 Closed Completed 11270440
REQ000000840216 12-03-14 10:45 Completed Submitted 21785118
REQ000000840216 19-11-14 14:10 Submitted Waiting Approval 18
REQ000000840216 19-11-14 14:10 Waiting Approval Planning 16257
REQ000000840216 19-11-14 18:41 Planning In Progress 66355
REQ000000840216 20-11-14 13:07 In Progress Closed 2434713
REQ000000874351 12-01-14 17:59 Planning In Progress 2646355
REQ000000874351 12-02-14 9:05 In Progress Completed 5123814
REQ000000874351 12-04-14 16:21 Completed Submitted 19690487
REQ000000874351 26-11-14 13:56 Submitted Waiting Approval 14
REQ000000874351 26-11-14 13:56 Waiting Approval Closed 1999991
REQ000000926286 12-08-14 12:42 Submitted Waiting Approval 10
REQ000000926286 12-08-14 12:42 Waiting Approval Planning 10904845
REQ000000926286 16-12-14 17:49 Planning In Progress 70660
REQ000000933197 12-09-14 13:14 Submitted Waiting Approval 15
REQ000000933197 12-09-14 13:14 Waiting Approval Planning 2848
REQ000000933197 12-09-14 14:02 Planning In Progress 10900
REQ000000933197 12-09-14 17:03 In Progress Closed 11359496
REQ000000933197 22-01-15 4:28 Closed Completed 11273250
REQ000000960902 15-12-14 13:29 Submitted Waiting Approval 12
REQ000000960902 15-12-14 13:29 Waiting Approval Planning 9745
REQ000000960902 15-12-14 16:11 Planning Cancelled 3112391
REQ000000967804 16-12-14 14:39 Submitted Waiting Approval 7
REQ000000967804 16-12-14 14:39 Waiting Approval Planning 171361
REQ000000967804 18-12-14 14:15 Planning In Progress 6018
REQ000001031235 01-07-15 13:22 Submitted Waiting Approval 4
REQ000001031235 01-07-15 13:22 Waiting Approval Planning 1117
REQ000001031235 01-07-15 13:41 Planning In Progress 1569
REQ000001042658 01-09-15 10:32 Submitted Waiting Approval 8
REQ000001042658 01-09-15 10:32 Waiting Approval Planning 16251
REQ000001042658 01-09-15 15:03 Planning In Progress 7840655
REQ000001043460 01-09-15 12:38 Submitted Waiting Approval 7
REQ000001043460 01-09-15 12:38 Waiting Approval Planning 8748
REQ000001043460 01-09-15 15:04 Planning In Progress 7842576
REQ000001043953 01-09-15 13:04 Submitted Waiting Approval 4
REQ000001043953 01-09-15 13:04 Waiting Approval Planning 7176
REQ000001043953 01-09-15 15:04 Planning In Progress 7846736
REQ000001044007 01-09-15 12:56 Submitted Waiting Approval 5
REQ000001044007 01-09-15 12:56 Waiting Approval Planning 7725
REQ000001044007 01-09-15 15:04 Planning In Progress 7844193
REQ000001160957 02-02-15 17:12 Submitted Waiting Approval 8
REQ000001160957 02-02-15 17:13 Waiting Approval Planning 2422879
REQ000001160957 02-03-15 18:14 Planning In Progress 4083
REQ000001161123 02-02-15 16:50 Submitted Waiting Approval 9
REQ000001161123 02-02-15 16:50 Waiting Approval Planning 2424231
REQ000001161123 02-03-15 18:14 Planning In Progress 6243
REQ000001161149 02-02-15 17:21 Submitted Waiting Approval 6
REQ000001161149 02-02-15 17:21 Waiting Approval Planning 2422344
REQ000001161149 02-03-15 18:14 Planning In Progress 2496
REQ000001161316 02-02-15 17:03 Submitted Waiting Approval 6
REQ000001161316 02-02-15 17:03 Waiting Approval Planning 2423463
REQ000001161316 02-03-15 18:14 Planning In Progress 5189
REQ000001270465 24-02-15 13:56 Submitted Waiting Approval 8
REQ000001270465 24-02-15 13:56 Waiting Approval Planning 619126
REQ000001270711 24-02-15 13:49 Submitted Waiting Approval 5
REQ000001270711 24-02-15 13:49 Waiting Approval Planning 619461
REQ000001270732 24-02-15 14:10 Submitted Waiting Approval 8
REQ000001270732 24-02-15 14:11 Waiting Approval Planning 618228

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
Closed 3 3 130.5 391.4
Completed 8 8 249.1 1,992.8
In Progress 11 11 46.7 513.9
Planning 24 24 18.3 438.3
Submitted 27 27 0.0 0.0
Waiting Approval 27 27 12.0 323.2

Time spent on transitions

count mean_days total_days
SR Audit Status Next status
Closed Completed 3 130.5 391.4
Completed Submitted 8 249.1 1,992.8
In Progress Closed 10 45.5 454.6
Completed 1 59.3 59.3
Planning Cancelled 1 36.0 36.0
In Progress 23 17.5 402.2
Submitted Waiting Approval 27 0.0 0.0
Waiting Approval Closed 1 23.1 23.1
Planning 26 11.5 300.1