Hi everyone!

I have a doubt about a calculation related to the duration between activities.

Normally the CALC THROUGHPUT formula is used to calculate durations between 2 activities.

However, I need to calculate the duration between more than 2 activities in a single KPI (e.g. the duration between activities A and B to activity C, or from A and B to C and D), but I can't get the formula.

I already have tried the following formula to calculare the duration between activities 'A' and 'C' to 'B'

AVG 

(

CASE

WHEN PROCESS EQUALS 'A' TO ANY TO 'B'

THEN CALC_THROUGHPUT(FIRST_OCCURRENCER'A'] TO LAST_OCCURRENCER'B'], 

REMAP_TIMESTAMPS("activity_table"."timestamp"))

WHEN PROCESS EQUALS 'C' TO ANY TO 'B'

THEN CALC_THROUGHPUT(FIRST_OCCURRENCEO'C'] TO LAST_OCCURRENCEO'B'], 

REMAP_TIMESTAMPS("activity_table"."timestamp", HOURS))

ELSE 0 END 

)

Can you help me?

Thank you very much!!