+5My issue is that I want to track changes for Activities like:
Activity 1 - manual - 0 (changes)
Activity 2 - automatic - 0 (changes)
Activity 3 - manual - 0 (changes)
Activity 1 - automatic - 1 (change)
Activity 2 - automatic - 0 (changes)
Activity 1 - manual - 2 (changes)
Each time the activity execution handling changes it should count +1.
Goal: To get an overview over the sum of execution changes per Activity over all cases.
+26
You can use Index_Order to iterate over rows. You can set an order to sort your activities chronologically and set a partition to group all the same items.
However, to mark a change over rows, in this case you should use the window functions 'Lead' or 'Lag'. You set a Lag function to check execution method of the previous activity (set activity name in the partition section) and set a count for each time this is not matching. See the examples in the Celonis Docs: LAG (celonis.com)
Hopefully this helps and let me know you need some clarification.
Kind regards,
Jan-peter
Enter your E-mail address. We'll send you an e-mail with instructions to reset your password.