Hello William,

I think using "FIRST_OCCURRENCE" will solve your problem

If I have understood your point correctly, the formula would look like : AVG(CALC_THROUGHPUT(FIRST_OCCURRENCE['A'] TO FIRST_OCCURRENCE['B'], REMAP_TIMESTAMPS("CEL_ACTIVITIES"."EVENTTIME", DAYS)))

Also, you can use the Visual Editor and specify First or Last Occurence by clicking on "Show More"

Hope I helped you,

Best regards,

François.

Hi François,

Thank you for answering I really appreciate it! This is something I have tried and it doesn't quite give what i'm looking for. Apologies I wasn't clear with the issue I'm having so have tried again below:

I've put numbers next to the activities just for clarification. So the formula you gave, which i've tried, will calculate the throughput time between A(2) and B(1). However, what i would like to know is the throughput time between A(2) and B(3) - so in general i want to know the throughput time between the first occurrence of activity A and the next occurrence of activity B immediately following A

B (1)

C

A (2)

D

B (3)

C

B (4)

A (5)

Hope that clarifies things and thank you again for taking the time to provide an answer

Hi William,

Indeed it is more complex

I am not sure because I haven't data allowing me to check it, but have you tried to use a "Process equals" or "Match_process" statement inside a filter (component filter for example) ?

By the way, you also can use those statement (Case When...) inside a CALC_THROUGHPUT function but I just figured out that using a CALC_THROUGHPUT may not be the solution because specifying the First or Last occurences crop the cases where for instance, you have not the activity in the normal order (first occurence won't take a cases where the activity is the last occurence)

An other option could be to use a Process flows selection or Crop selection in "Add a new selection", can it help ?

Hope one of those solution will help, let me know if it does

I regret to not be more helpful at the moment, I will come back to you if I find a better way,

François