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

15.8% Completed 0.0% Draft 28.0% In Progress 31.5% Planning 0.0% Rejected 0.0% Submitted 24.7% 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 217

Service Request ID SR Audit Create Datetime SR Audit Status Next status Time spent
REQ000000612161 10-01-14 12:51 Submitted Waiting Approval 10
REQ000000612161 10-01-14 12:51 Waiting Approval Planning 5912
REQ000000612161 10-01-14 14:30 Planning Completed 5249743
REQ000000612161 10-06-14 6:09 In Progress Closed 16543031
REQ000000612161 12-03-14 8:46 Completed In Progress 7766599
REQ000000695867 11-03-14 10:15 In Progress Submitted 19282668
REQ000000695867 20-10-14 14:32 Submitted Waiting Approval 18
REQ000000695867 20-10-14 14:33 Waiting Approval Planning 3240
REQ000000695867 20-10-14 15:27 Planning Pending 5662
REQ000000717697 11-06-14 17:03 In Progress Submitted 11638141
REQ000000717697 24-10-14 9:52 Submitted Waiting Approval 10
REQ000000717697 24-10-14 9:52 Waiting Approval Planning 335599
REQ000000724670 11-06-14 17:30 In Progress Submitted 11895582
REQ000000724670 27-10-14 9:50 Submitted Waiting Approval 12
REQ000000724670 27-10-14 9:50 Waiting Approval Planning 274807
REQ000000725021 11-06-14 17:35 In Progress Submitted 11894963
REQ000000725021 27-10-14 9:44 Submitted Waiting Approval 9
REQ000000725021 27-10-14 9:45 Waiting Approval Planning 275142
REQ000000727362 11-06-14 12:12 In Progress Submitted 11934120
REQ000000727362 27-10-14 15:14 Submitted Waiting Approval 15
REQ000000727362 27-10-14 15:14 Waiting Approval Planning 255384
REQ000000727363 11-06-14 10:56 In Progress Submitted 11938808
REQ000000727363 27-10-14 15:16 Submitted Waiting Approval 16
REQ000000727363 27-10-14 15:16 Waiting Approval Planning 255253
REQ000000727376 11-06-14 10:51 In Progress Submitted 11939489
REQ000000727376 27-10-14 15:22 Submitted Waiting Approval 20
REQ000000727376 27-10-14 15:22 Waiting Approval Planning 254916
REQ000000727570 11-06-14 10:53 In Progress Submitted 11939122
REQ000000727570 27-10-14 15:18 Submitted Waiting Approval 15
REQ000000727570 27-10-14 15:19 Waiting Approval Planning 255116
REQ000000727580 11-06-14 10:37 In Progress Submitted 11940480
REQ000000727580 27-10-14 15:25 Submitted Waiting Approval 15
REQ000000727580 27-10-14 15:25 Waiting Approval Planning 254747
REQ000000728547 11-06-14 9:59 In Progress Submitted 11952401
REQ000000728547 27-10-14 18:06 Submitted Waiting Approval 11
REQ000000728547 27-10-14 18:06 Waiting Approval Planning 148783
REQ000000739363 12-03-14 8:36 Completed Submitted 19964697
REQ000000739363 29-10-14 10:21 Submitted Waiting Approval 18
REQ000000739363 29-10-14 10:22 Waiting Approval Planning 12588
REQ000000739363 29-10-14 13:52 Planning In Progress 1293
REQ000000739363 29-10-14 14:13 In Progress Closed 4331585
REQ000000739575 12-03-14 8:42 Completed Submitted 19967952
REQ000000739575 29-10-14 11:21 Submitted Waiting Approval 14
REQ000000739575 29-10-14 11:21 Waiting Approval Planning 9034
REQ000000739575 29-10-14 13:52 Planning In Progress 4398
REQ000000739575 29-10-14 15:05 In Progress Closed 4328473
REQ000000739629 12-03-14 8:37 Completed Submitted 19966734
REQ000000739629 29-10-14 10:56 Submitted Waiting Approval 11
REQ000000739629 29-10-14 10:56 Waiting Approval Planning 10544
REQ000000739629 29-10-14 13:52 Planning In Progress 3056
REQ000000739629 29-10-14 14:43 In Progress Closed 4329815
REQ000000771171 11-05-14 13:15 Planning In Progress 13218918
REQ000000771171 11-05-14 8:44 Submitted Waiting Approval 13
REQ000000771171 11-05-14 8:45 Waiting Approval Planning 16232
REQ000000771171 11-10-14 13:10 In Progress Cancelled 2660622
REQ000000771380 11-05-14 13:15 Planning In Progress 13220553
REQ000000771380 11-05-14 8:52 Submitted Waiting Approval 15
REQ000000771380 11-05-14 8:52 Waiting Approval Planning 15803
REQ000000771380 11-10-14 13:38 In Progress Cancelled 2659048
REQ000000771610 11-05-14 13:15 Planning In Progress 13217000
REQ000000771610 11-05-14 8:39 Submitted Waiting Approval 12
REQ000000771610 11-05-14 8:39 Waiting Approval Planning 16547
REQ000000771610 11-10-14 12:38 In Progress Cancelled 2662404
REQ000000837895 12-03-14 10:55 Completed Submitted 21768835
REQ000000837895 19-11-14 10:20 In Progress Closed 2531133
REQ000000837895 19-11-14 9:49 Submitted Waiting Approval 21
REQ000000837895 19-11-14 9:49 Waiting Approval Planning 401
REQ000000837895 19-11-14 9:56 Planning In Progress 1475
REQ000000838021 12-03-14 10:53 Completed Submitted 21768493
REQ000000838021 19-11-14 10:04 In Progress Closed 2532110
REQ000000838021 19-11-14 9:41 Submitted Waiting Approval 15
REQ000000838021 19-11-14 9:41 Waiting Approval Planning 859
REQ000000838021 19-11-14 9:55 Planning In Progress 515
REQ000000904285 12-03-14 20:50 Planning In Progress 21139569
REQ000000904285 12-03-14 8:02 Submitted Waiting Approval 58
REQ000000904285 12-03-14 8:03 Waiting Approval Planning 46050
REQ000000927976 12-08-14 15:56 Submitted Waiting Approval 9
REQ000000927976 12-08-14 15:56 Waiting Approval Planning 2677679
REQ000000927976 12-09-14 15:44 Planning In Progress 7839936
REQ000000933497 12-09-14 13:59 Submitted Waiting Approval 29
REQ000000933497 12-09-14 14:00 Waiting Approval Planning 8119011
REQ000000933497 15-12-14 13:17 Planning In Progress 90391
REQ000000941240 12-10-14 15:09 Submitted Waiting Approval 15
REQ000000941240 12-10-14 15:09 Waiting Approval Planning 6200400
REQ000000941240 23-12-14 9:29 Planning In Progress 13847263
REQ000000941516 12-10-14 15:12 Submitted Waiting Approval 18
REQ000000941516 12-10-14 15:12 Waiting Approval Planning 6200211
REQ000000941516 23-12-14 9:29 Planning In Progress 13847383
REQ000000983374 01-05-15 16:18 Planning In Progress 2656528
REQ000000983374 19-12-14 10:05 Submitted Waiting Approval 14
REQ000000983374 19-12-14 10:06 Waiting Approval Planning 11513544
REQ000000989915 22-12-14 9:57 Submitted Waiting Approval 6
REQ000000989915 22-12-14 9:57 Waiting Approval Planning 177149
REQ000000989915 24-12-14 11:10 Planning In Progress 11078789
REQ000000991036 22-12-14 13:28 Submitted Waiting Approval 6
REQ000000991036 22-12-14 13:28 Waiting Approval Planning 164508
REQ000000991036 24-12-14 11:10 Planning In Progress 11073328
REQ000000991551 22-12-14 15:05 Submitted Waiting Approval 6
REQ000000991551 22-12-14 15:05 Waiting Approval Planning 158664
REQ000000991551 24-12-14 11:10 Planning In Progress 11081844

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
Completed 6 6 214.5 1,287.1
Draft 2 2 0.0 0.0
In Progress 21 21 108.7 2,283.6
Planning 54 54 47.6 2,569.1
Rejected 2 2 0.0 0.0
Submitted 66 66 0.0 0.0
Waiting Approval 66 66 30.6 2,019.1

Time spent on transitions

count mean_days total_days
SR Audit Status Next status
Completed In Progress 1 89.9 89.9
Submitted 5 239.4 1,197.2
Draft Submitted 2 0.0 0.0
In Progress Cancelled 3 30.8 92.4
Closed 6 66.7 400.4
Completed 1 6.1 6.1
Submitted 11 162.2 1,784.7
Planning Completed 1 60.8 60.8
In Progress 52 48.2 2,508.3
Pending 1 0.1 0.1
Rejected Draft 2 0.0 0.0
Submitted Waiting Approval 66 0.0 0.0
Waiting Approval Planning 64 31.5 2,019.0
Rejected 2 0.0 0.0