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