Question

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

Forum|Forum|3 years ago
February 8, 2023
1 reply
12 views

Forum|alt.badge.img

+10

preetham.h.m
Level 0

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

Forum|alt.badge.img

+14

rio.cinco12
Level 8
Forum|Forum|3 years ago
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

Like