I need to count the number of invoices which follows a process flow 'Payment after Due date passed'.
Page 1 / 1
Hi, you can do Match Process , something like below. It means Payment "directly follow" Due date passed.
COUNT(
CASE WHEN MATCH_PROCESS_REGEX ( "Table1"."ACTIVITY" , 'Payment' >> 'Due date passed' ) = 1
THEN 1.0
ELSE NULL
END )
https://docs.celonis.com/en/match_process_regex.html
Best,
R
Reply
Enter your E-mail address. We'll send you an e-mail with instructions to reset your password.