I need to calculate the time between two activities that are not directly followed by each other taking an event attribute into account.
Example:
Calculate time between A and B where:
- Both activities A and B happen more than once in the process
- To get the correct throughput time, we need to consider an activity attribute (e.g., campaign_id). In our case, if activity A happens three times, it will have three distinct campaign ids, so we need to match those ids with the ones in activity B.
How can I implement that in Celonis?
I tried using SOURCE() and TARGET() from the example in this post , but it seems it only works for directly followed by activities, so there was no data for my chart, as A is never directly followed by B in this case.
Thanks a lot in advance!