Skip to main content

Hi Celopeers!

I am wondering what is the most convenient way to get the average throughput time between two activities based on their occurrence in a case.

 

lets say C and D are always related to one another but can occur any time in one case:

 

e.g. for the following 3 cases:

A-B-B-C-C-C-D-D

A-B-C-B-B-D-C-D

A-B-C-D

 

What is the best way to get the average TPT between each C and D based on the index in the case?

so always...

A-B-B-C1-C2-C3-D1-D2

A-B-C1-B-B-D1-C2-D2

A-B-C1-D1

 

C1-D1

C2-D2

C3-D3

...

 

I have thought of: LEAD/LAG; ACTIVITY_LEAD/LAG, SOURCE/TARGET, CALC_THROUGHPUT, ... in combination with INDEX_ACTIVITY_TYPE but I have not come up with the perfect solution yet.

 

Thanks a lot!

 

Hi Lars

 

I would suggest one approach (problably there are thousand better). As the case is not more relevant for this problem, I would explode the cases in one new activity table with case key = old case key & INDEX_ACTIVITY_TYPE, and ACTIVITY = C or D, if you want the difentiation of 1,2,3,4... then you have to add to the activity name & INDEX_ACTIVITY_TYPE,

 

Then should be easy to use AVG(CALC_THROUGHPUT) with the new activity table.

 

Hope it helps, I am not sure if I made myself clear enough.

 

Best.

Javier


Hi Javier,

Thanks for your answer. Actually I did now solve it via SQL in the Event collection, by inserting an additional timestamp field for C and D. I am still wondering if I miss another option.

E.g. What I would find really helpful is to have an edge_configuration for SOURCE-TARGET that enables these sorts of analyses. This would be really handy for analyzing partial invoices, goods receipt, inspection lots, deliveries etc :-)

Best,

Lars


Reply