Hi, 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 processTo 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!

Question

Time between two activities based on activity attribute

Forum|Forum|5 years ago
February 4, 2020
3 replies
23 views

joão.macie
Level 1

Hi, 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!

J

joão.macie
Author
Level 1
Forum|Forum|5 years ago
February 4, 2020

Update: I was able to reproduce the solution with the OLAP table as described on this post However, I need a column chart where the dimension is based on a timestamp (e.g., round day, or week, or month). The problem now is that whenever I change the dimension other than the source activity, the KPI returns wrong values. Anyone had a similar case or know how to help? Thanks and best, Joao