Hi Steven,

who and how will it be decided to swap the activitiesis?

Why are you not using two different components? One showing the time interval from toPAS: QT5.2 - Check successful to XI release and the other one from XI release to toPAS: QT5.2 - Check successul?

BR

Dennis

Thanks for your answer, the order of the activities actually doesn't matter, it's important that the time gap between the two activities doesn't become too large. I didn't want to have 2 KPIs displayed, depending on which activity occurs first. I would like to have this either or test integrated into a KPI.

Steven

Ok got it.

I think it should work like this:

TRIMMED_MEAN(CASE WHEN PU_FIRST("CASE_TABLE","T_CEL_AT_HP5"."EVENTTIME", "T_CEL_AT_HP5"."EVENTTIME"."ACTIVITY_EN" = 'toPAS: QT5.2 - Check successful') < PU_FIRST("CASE_TABLE","T_CEL_AT_HP5"."EVENTTIME", "T_CEL_AT_HP5"."ACTIVITY_EN" = 'XI release') THEN

(CALC_THROUGHPUT(FIRST_OCCURRENCEC'toPAS: QT5.2 - Check successful'] TO FIRST_OCCURRENCEC'XI release'], REMAP_TIMESTAMPS("T_CEL_AT_HP5"."EVENTTIME", DAYS, MONDAY TUESDAY WEDNESDAY THURSDAY FRIDAY)))

ELSE

(CALC_THROUGHPUT(FIRST_OCCURRENCEC'XI released'] TO FIRST_OCCURRENCEC'toPAS: QT5.2 - Check successful'], REMAP_TIMESTAMPS("T_CEL_AT_HP5"."EVENTTIME", DAYS, MONDAY TUESDAY WEDNESDAY THURSDAY FRIDAY)))

END,5,5)

BR

Dennis

the formula works perfectly. Thank you for that