Average throughput times for two target process flows

Hello,

i would like to calculate the combined average time that it takes to move from:

Step 3 -> Step 4 (3 days)
Step 3 -> Step 5 (5 days)

The result i am looking for should be 4 days (for illustration, both process happen once above). I have written the following code but get an error returned to me:

AVG(AVG(CALC_THROUGHPUT(FIRST_OCCURRENCE[‘Step 3’] TO LAST_OCCURRENCE[‘Step 4’], REMAP_TIMESTAMPS(“TABLE_TRANSFORMED”.“AUDITTIMESTAMP”, DAYS))) AND AVG(CALC_THROUGHPUT(FIRST_OCCURRENCE[‘Step 3’] TO LAST_OCCURRENCE[‘Step 5’], REMAP_TIMESTAMPS(“TABLE_TRANSFORMED”.“AUDITTIMESTAMP”, DAYS))))

Would anyone be able to advise on this?

Best,
Dominic

Hi Dominc,

in order to being able to support you on your query - do you want to calculate the average time it takes from Step 3 to every first following activity or just to Step 4 and Step 5?

Best regards,
Viana