Dear Colleagues,

a quick question. We can easily calculate either:

DAYS_BETWEEN(PU_FIRST(Activity1), PU_LAST(Activity2))

or use

CALC_THROUGHPUT(FIRST_OCCURRENCE[Activity1] TO LAST_OCCURRENCE[Activity2]

but is there any easy way to calculate the throughput but for various cobmination of activities?

I used SOURCE(Activity) and TARGET(Activity) which gives me a table with combinations of activities, but I cannot add any KPI which would calculate the throughput for this combination.

So what I would like to achieve:

Source(activity) Target(actvity) Average Throughput time

A1 A2 3

A1 A3 2

A2 A4 5

and so on…