Hello,

for some reason I can´t find any solution online for this problem. It is probably out there but I cant find it.

I simply want to showcase the following:

The Average throughput time between Activity A and C, but ignore all cases where it touched Activity B inbetween.

This feels like a very easy task but I can´t seem to find how to filter out Activity B.

Basically I thought it would like this:

AVG (

 CALC_THROUGHPUT (

  FIRST_OCCURRENCE O 'A' ]

  TO

  LAST_OCCURRENCE A 'C' ] ,

  REMAP_TIMESTAMPS ( "_CEL_O2C_ACTIVITIES"."EVENTTIME" , DAYS )

 )

)

And then in the component filter:

FILTER "_CEL_O2C_ACTIVITIES"."ACTIVITY_EN" NOT IN ('B')

This obviously doesn´t work so I am here.

Maybe someone can answer me this rather simple question I suppose.

Thanks!