Skip to main content
Question

How can I merge a component filter formula and a number KPI formula to create a new KPI formula

  • February 8, 2023
  • 1 reply
  • 6 views

Forum|alt.badge.img+10

I need to count the number of invoices which follows a process flow 'Payment after Due date passed'.

1 reply

Forum|alt.badge.img+14
  • Level 8
  • February 9, 2023

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