Hey all,
I have a process where I have four activities labeled: A, B, C, D.
In the event log I have for one case equal timestamps for B and C: 08:11:00 until 08:23:00.
My problem is that Celonis visualizes this process as A → B → C → D, however I expect the process to look like A → B, C → D.
Is there any way to do this, and if so, how?
Hello gertjan,
did you try to insert sortings in the Transformation SQL Code of the activities, maybe this one can solve the Problem.
This Sorting is for the Order of activities with the same Timestamps, but I am not sure if this works only if you have the same timestamps in the same activities, or if it also works when there are the same Timestamps in different activities.
Kind regards Jonas
Hi Jonas,
Thank you for answering, but wouldn’t sorting still allow the process to have sequential ordering?
Right now I have this variant for example:
And here you can see the data specifically:
But I want it to show it like this:
As you can see in the variant, B comes after C, but this doesn’t make sense, since B and C have the same timestamp.
Enter your E-mail address. We'll send you an e-mail with instructions to reset your password.