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

0.0% Draft 79.6% In Progress 19.9% Planning 0.0% Rejected 0.0% Submitted 0.5% 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 86 out of 86

Service Request ID SR Audit Create Datetime SR Audit Status Next status Time spent
REQ000000865976 12-01-14 9:27 In Progress Submitted 27394116
REQ000000865976 25-11-14 10:56 Submitted Waiting Approval 17
REQ000000865976 25-11-14 10:56 Waiting Approval Planning 184519
REQ000000871992 12-01-14 21:58 Planning In Progress 7745936
REQ000000871992 12-04-14 13:37 In Progress Submitted 19684604
REQ000000871992 26-11-14 9:33 Submitted Waiting Approval 24
REQ000000872438 12-01-14 21:59 Planning In Progress 7746648
REQ000000872438 12-04-14 13:49 In Progress Submitted 19683002
REQ000000872438 26-11-14 9:20 Submitted Waiting Approval 23
REQ000000872438 26-11-14 9:20 Waiting Approval Rejected 423
REQ000000872438 26-11-14 9:27 Rejected Draft 67
REQ000000872438 26-11-14 9:28 Draft Submitted 77
REQ000000872438 26-11-14 9:29 Submitted Waiting Approval 1
REQ000000872438 26-11-14 9:29 Waiting Approval Rejected 350
REQ000000872438 26-11-14 9:35 Rejected Draft 36
REQ000000872438 26-11-14 9:36 Draft Submitted 84
REQ000000872445 12-01-14 21:58 Planning In Progress 7746299
REQ000000872445 12-04-14 13:43 In Progress Submitted 19683615
REQ000000872445 26-11-14 9:23 Submitted Waiting Approval 19
REQ000000872445 26-11-14 9:24 Waiting Approval Rejected 1530
REQ000000872445 26-11-14 9:49 Rejected Draft 32
REQ000000872445 26-11-14 9:50 Draft Submitted 23
REQ000000872445 26-11-14 9:50 Submitted Waiting Approval 1
REQ000000872666 12-01-14 22:03 Planning In Progress 5046370
REQ000000872666 12-03-14 7:49 In Progress Submitted 22388007
REQ000000872666 26-11-14 10:43 Submitted Waiting Approval 19
REQ000000872883 12-01-14 22:01 Planning In Progress 5050461
REQ000000872883 12-03-14 8:56 In Progress Submitted 22383686
REQ000000872883 26-11-14 10:37 Submitted Waiting Approval 15
REQ000000872899 12-01-14 22:03 Planning In Progress 2653356
REQ000000872899 12-02-14 15:05 In Progress Submitted 24781502
REQ000000872899 26-11-14 10:50 Submitted Waiting Approval 20
REQ000000872970 12-01-14 22:02 Planning In Progress 5046120
REQ000000872970 12-03-14 7:44 In Progress Submitted 22388491
REQ000000872970 26-11-14 10:45 Submitted Waiting Approval 16
REQ000000872977 12-01-14 22:03 Planning In Progress 5045594
REQ000000872977 12-03-14 7:36 In Progress Submitted 22389126
REQ000000872977 26-11-14 10:48 Submitted Waiting Approval 18
REQ000000873009 12-01-14 22:00 Planning In Progress 7745415
REQ000000873009 12-04-14 13:30 In Progress Submitted 19685426
REQ000000873009 26-11-14 9:40 Submitted Waiting Approval 24
REQ000000873011 12-01-14 21:58 Planning In Progress 7745201
REQ000000873011 12-04-14 13:25 In Progress Submitted 19686004
REQ000000873011 26-11-14 9:45 Submitted Waiting Approval 21
REQ000000873777 12-01-14 22:00 Planning In Progress 7744818
REQ000000873777 12-04-14 13:21 In Progress Submitted 19697754
REQ000000873777 26-11-14 12:57 Submitted Waiting Approval 15
REQ000000873777 26-11-14 12:57 Waiting Approval Rejected 4701
REQ000000873777 26-11-14 14:15 Rejected Draft 916
REQ000000873777 26-11-14 14:30 Draft Submitted 29
REQ000000873777 26-11-14 14:31 Submitted Waiting Approval 1
REQ000000873980 12-01-14 22:00 Planning In Progress 5057114
REQ000000873980 12-03-14 10:45 In Progress Submitted 22387396
REQ000000873980 26-11-14 13:29 Submitted Waiting Approval 17
REQ000000873980 26-11-14 13:29 Waiting Approval Rejected 2634
REQ000000873980 26-11-14 14:13 Rejected Draft 809
REQ000000873980 26-11-14 14:26 Draft Submitted 46
REQ000000873980 26-11-14 14:27 Submitted Waiting Approval 1
REQ000000874140 12-01-14 22:01 Planning In Progress 7744496
REQ000000874140 12-04-14 13:16 In Progress Submitted 19699626
REQ000000874140 26-11-14 13:23 Submitted Waiting Approval 20
REQ000000874140 26-11-14 13:23 Waiting Approval Rejected 3029
REQ000000874140 26-11-14 14:14 Rejected Draft 877
REQ000000874140 26-11-14 14:28 Draft Submitted 27
REQ000000874379 12-01-14 22:00 Planning In Progress 5056718
REQ000000874379 12-03-14 10:38 In Progress Submitted 22391108
REQ000000874379 26-11-14 14:24 Submitted Waiting Approval 31
REQ000000874617 12-01-14 22:01 Planning In Progress 5056235
REQ000000874617 12-03-14 10:32 In Progress Submitted 22390289
REQ000000874617 26-11-14 14:03 Submitted Waiting Approval 20
REQ000001124891 19-02-15 16:07 In Progress Planning 22092903
REQ000001124891 26-01-15 14:33 Submitted Waiting Approval 15
REQ000001124891 26-01-15 14:33 Waiting Approval Rejected 169134
REQ000001124891 28-01-15 13:32 Rejected Draft 88
REQ000001124891 28-01-15 13:34 Draft Submitted 120
REQ000001124891 28-01-15 13:36 Submitted Waiting Approval 1
REQ000001124891 28-01-15 13:36 Waiting Approval In Progress 1909911
REQ000001194092 02-09-15 12:33 Submitted Waiting Approval 10
REQ000001194092 02-09-15 12:33 Waiting Approval Rejected 9589
REQ000001194092 02-09-15 15:13 Rejected Draft 1224
REQ000001194092 02-09-15 15:33 Draft Submitted 31
REQ000001194524 02-09-15 12:28 Submitted Waiting Approval 5
REQ000001194524 02-09-15 12:28 Waiting Approval Rejected 9945
REQ000001194524 02-09-15 15:14 Rejected Draft 1159
REQ000001194524 02-09-15 15:33 Draft Submitted 91
REQ000001194524 02-09-15 15:34 Submitted Waiting Approval 1

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
Draft 9 9 0.0 0.0
In Progress 17 17 251.1 4,268.6
Planning 15 15 71.2 1,067.5
Rejected 9 9 0.0 0.1
Submitted 25 25 0.0 0.0
Waiting Approval 11 11 2.4 26.6

Time spent on transitions

count mean_days total_days
SR Audit Status Next status
Draft Submitted 9 0.0 0.0
In Progress Planning 1 255.7 255.7
Submitted 16 250.8 4,012.9
Planning In Progress 15 71.2 1,067.5
Rejected Draft 9 0.0 0.1
Submitted Waiting Approval 25 0.0 0.0
Waiting Approval In Progress 1 22.1 22.1
Planning 1 2.1 2.1
Rejected 9 0.3 2.3