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!