+7Hello Everyone,
I have a scenario where I need to calculate the automation rate of a process. However, there is a specific condition: I need to exclude all activities that occur between the Approval Task Start and Approval Task End. These approval segments may appear multiple (N) times throughout the entire process.
Please let me know if you have encountered a similar situation before or if you have any recommended approach for handling this type of exclusion logic.
+8Hi kailash,
indeed a tricky requirement the way you described it. I do not have a good solution but thought a few minutes about your problem maybe the direction helps you. As apparently there is no solutions so far by someone else. So either way I want to subscribe to see if you come up with a proper solution at the end.
I’d consider the PQL functions under “Process” https://docs.celonis.com/en/process.html.
Especially I was thinking around SOURCE-TARGET.
This unfortunately requires a specific offset to the activity Approval Task Start /End but maybe you can create messy case when Source (1 step) = ‘Approval Task Start” OR SOURCE (2 step) = ‘Approval Task Start” …. THEN NULL ELSE AUTOMATION Status.
Enter your E-mail address. We'll send you an e-mail with instructions to reset your password.