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

2.2% Closed 25.5% Completed 0.2% Draft 42.3% In Progress 0.0% Pending 16.4% Planning 0.0% Rejected 0.0% Submitted 13.4% 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 129

Service Request ID SR Audit Create Datetime SR Audit Status Next status Time spent
REQ000000641411 10-08-14 12:13 Submitted Waiting Approval 16
REQ000000641411 10-08-14 12:13 Waiting Approval Planning 272
REQ000000641411 10-08-14 12:18 Planning In Progress 2656352
REQ000000641411 10-09-14 6:11 In Progress Closed 8507458
REQ000000641411 12-02-14 9:48 Completed Submitted 15474322
REQ000000668299 11-05-14 10:23 In Progress Draft 13492691
REQ000000668299 14-10-14 14:21 Draft Submitted 491863
REQ000000668299 20-10-14 6:59 Submitted Waiting Approval 17
REQ000000668299 20-10-14 6:59 Waiting Approval Planning 839833
REQ000000668299 30-10-14 0:17 Planning Pending 140347
REQ000000675376 15-10-14 15:06 Draft Submitted 402465
REQ000000675376 20-10-14 6:53 Submitted Waiting Approval 20
REQ000000675376 20-10-14 6:54 Waiting Approval Rejected 4000
REQ000000675376 20-10-14 8:00 Rejected Draft 523
REQ000000675376 20-10-14 8:09 Draft Submitted 78
REQ000000675376 20-10-14 8:10 Submitted Waiting Approval 1
REQ000000675376 20-10-14 8:10 Waiting Approval Planning 835551
REQ000000675376 30-10-14 0:16 Planning In Progress 139841
REQ000000693082 20-10-14 8:43 Submitted Waiting Approval 21
REQ000000693082 20-10-14 8:44 Waiting Approval Planning 833547
REQ000000693082 30-10-14 0:16 Planning In Progress 141747
REQ000000693082 31-10-14 15:38 In Progress Completed 9989800
REQ000000700617 12-03-14 9:52 Completed Submitted 19266140
REQ000000700617 21-10-14 14:36 Planning In Progress 75637
REQ000000700617 21-10-14 9:35 Submitted Waiting Approval 11
REQ000000700617 21-10-14 9:35 Waiting Approval Planning 18053
REQ000000700617 22-10-14 11:36 In Progress Closed 4945792
REQ000000700627 12-03-14 9:53 Completed Submitted 19266296
REQ000000700627 21-10-14 14:36 Planning In Progress 77093
REQ000000700627 21-10-14 9:38 Submitted Waiting Approval 19
REQ000000700627 21-10-14 9:38 Waiting Approval Planning 17845
REQ000000700627 22-10-14 12:01 In Progress Closed 4944325
REQ000000717258 11-03-14 13:48 Planning In Progress 7933991
REQ000000717258 11-06-14 9:41 In Progress Submitted 11657282
REQ000000717258 24-10-14 7:49 Submitted Waiting Approval 10
REQ000000718076 11-06-14 17:41 In Progress Submitted 11640687
REQ000000718076 24-10-14 11:12 Submitted Waiting Approval 8
REQ000000718076 24-10-14 11:12 Waiting Approval Planning 285037
REQ000000726965 11-03-14 11:56 Planning In Progress 2695301
REQ000000726965 11-04-14 16:38 In Progress Submitted 17184684
REQ000000726965 27-10-14 14:09 Submitted Waiting Approval 15
REQ000000728289 11-06-14 10:07 In Progress Submitted 11951636
REQ000000728289 27-10-14 18:01 Submitted Waiting Approval 9
REQ000000728289 27-10-14 18:01 Waiting Approval Planning 224094
REQ000000741785 12-02-14 10:35 Completed Submitted 22397923
REQ000000741785 29-10-14 16:14 Submitted Waiting Approval 17
REQ000000741785 29-10-14 16:14 Waiting Approval Planning 11430
REQ000000741785 29-10-14 19:24 Planning In Progress 817
REQ000000741785 29-10-14 19:38 In Progress Closed 4225400
REQ000000742058 12-02-14 10:35 Completed Submitted 22401258
REQ000000742058 29-10-14 17:10 Submitted Waiting Approval 16
REQ000000742058 29-10-14 17:10 Waiting Approval Planning 8072
REQ000000742058 29-10-14 19:24 Planning In Progress 2587
REQ000000742058 29-10-14 20:08 In Progress Closed 4223626
REQ000000747243 11-06-14 13:05 In Progress Submitted 12187530
REQ000000747243 30-10-14 14:31 Submitted Waiting Approval 15
REQ000000747243 30-10-14 14:31 Waiting Approval Planning 72133
REQ000000747349 11-06-14 13:09 In Progress Submitted 12187151
REQ000000747349 30-10-14 14:28 Submitted Waiting Approval 12
REQ000000747349 30-10-14 14:28 Waiting Approval Planning 72304
REQ000000771222 11-05-14 8:07 Submitted Waiting Approval 10
REQ000000771222 11-05-14 8:08 Waiting Approval In Progress 16176797
REQ000000771222 11-12-14 9:16 Planning Completed 2947658
REQ000000771222 14-01-15 12:04 Completed Closed 1335833
REQ000000771222 14-11-14 13:41 In Progress Planning 2316910
REQ000000784389 11-07-14 9:49 Submitted Waiting Approval 13
REQ000000784389 11-07-14 9:49 Waiting Approval Planning 10629466
REQ000000784389 11-11-14 10:27 Planning In Progress 612830
REQ000000872872 12-01-14 8:25 In Progress Submitted 27482284
REQ000000872872 26-11-14 10:23 Submitted Waiting Approval 22
REQ000000872872 26-11-14 10:23 Waiting Approval Planning 3360
REQ000000905941 12-03-14 10:45 Submitted Waiting Approval 43
REQ000000905941 12-03-14 10:45 Waiting Approval Planning 706
REQ000000905941 12-03-14 10:57 Planning In Progress 5675
REQ000000905941 12-03-14 12:32 In Progress Completed 5269584
REQ000000905941 12-05-14 12:18 Completed Closed 19199731
REQ000000913378 12-04-14 12:50 Submitted Waiting Approval 13
REQ000000913378 12-04-14 12:50 Waiting Approval Planning 2579372
REQ000000913378 12-05-14 9:20 Planning In Progress 15921546
REQ000000914678 12-04-14 15:54 Submitted Waiting Approval 10
REQ000000914678 12-04-14 15:55 Waiting Approval Planning 28958
REQ000000914678 12-04-14 23:57 Planning In Progress 2554993
REQ000000914678 12-05-14 13:40 In Progress Closed 21998865
REQ000000914678 22-01-15 4:28 Closed Completed 11270788
REQ000000914870 12-04-14 15:52 Submitted Waiting Approval 14
REQ000000914870 12-04-14 15:52 Waiting Approval Planning 29072
REQ000000914870 12-04-14 23:57 Planning In Progress 2554379
REQ000000914870 12-05-14 13:30 In Progress Completed 10613604
REQ000000914870 12-09-14 9:43 Completed Closed 8927949
REQ000000942972 12-10-14 22:43 Submitted Waiting Approval 9
REQ000000942972 12-10-14 22:43 Waiting Approval Planning 2632103
REQ000000942972 12-11-14 9:51 Planning In Progress 27820
REQ000000948282 12-11-14 18:38 Submitted Waiting Approval 10
REQ000000948282 12-11-14 18:38 Waiting Approval Planning 3442130
REQ000000948282 22-12-14 14:47 Planning In Progress 616061
REQ000000948722 12-11-14 18:16 Submitted Waiting Approval 11
REQ000000948722 12-11-14 18:16 Waiting Approval Planning 3443457
REQ000000948722 22-12-14 14:47 Planning In Progress 616874
REQ000000983448 01-05-15 11:54 Planning In Progress 7944307
REQ000000983448 19-12-14 10:00 Submitted Waiting Approval 6

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 1 1 130.4 130.4
Completed 8 8 185.6 1,484.6
Draft 3 3 3.5 10.4
In Progress 20 20 122.8 2,456.0
Pending 1 1 0.2 0.2
Planning 28 28 34.0 952.2
Rejected 1 1 0.0 0.0
Submitted 35 35 0.0 0.0
Waiting Approval 32 32 24.3 777.5

Time spent on transitions

count mean_days total_days
SR Audit Status Next status
Closed Completed 1 130.4 130.4
Completed Closed 3 113.7 341.0
Submitted 5 228.7 1,143.6
Draft Submitted 3 3.5 10.4
In Progress Cancelled 1 0.0 0.0
Closed 6 94.2 565.3
Completed 3 99.8 299.5
Draft 1 156.2 156.2
Planning 1 26.8 26.8
Submitted 8 176.0 1,408.2
Pending In Progress 1 0.2 0.2
Planning Completed 1 34.1 34.1
In Progress 25 25.2 630.4
Pending 2 143.8 287.7
Rejected Draft 1 0.0 0.0
Submitted Waiting Approval 35 0.0 0.0
Waiting Approval In Progress 1 187.2 187.2
Planning 30 19.7 590.2
Rejected 1 0.0 0.0