Hello all,

I would like to calculate the througput time from activity to next different activity.

The Challenge:

My process has activities which occurs multiple times with the same name directly one after the other. This is no data issue, the process is designed that way.

In case the activity with the same name occurs later in the process again, this should be count as well and not ignored.

What is the time to the next activity, which does not have the same name?

Process example:

Avtivity       Timestamp

A    01:00 pm

B    01:30 pm

B    01:45 pm

B    02:15 pm

C    03:00 pm

C    03:20 pm

D    03:45 pm

E    04:00 pm

E    04:50 pm

A    05:00 pm

Expected Result:

Avtivity       Duration

A                30min

B                1h 30min

C                45min

D                15min

E                10min

Does anybody know a solution or a community post, which can help me?