For the above filter, i would like to use the AND function and include both of the activities for filtering the data.
For the above filter, i would like to use the AND function and include both of the activities for filtering the data.
instead of NODE you can use NODE_ANY and then specify the additional activities in the [] e.g.
FILTER MATCH_ACTIVITIES ( "<your activity table>"."<your activity column>" , NODE [ 'Clear Invoice', 'Process invoice' ] ) = 0;
- NODE: case has to have the specified activities
- NODE_ANY: case has to have at least one of the specified activities
- FILTER MATCH_ACTIVITIES ( "Table1"."ACTIVITY" , NODE_ANY Y 'B' , 'C' ] ) = 1;
https://docs.celonis.com/en/match_activities.html
Thank you very much Sunny for your support. Is it possible to convert this filter into a KPI?
Thank you very much Sunny for your support. Is it possible to convert this filter into a KPI?
I usually use a CASE WHEN statement to evaluate whether the formula is true and then and a count or sum around the top. e.g.
COUNT(CASE WHEN MATCH_ACTIVITIES ( "<your activity table>"."<your activity column>" , NODE 'Clear Invoice', 'Process invoice' ] ) = 1 THEN 1 ELSE 0 END)
Thank you Sunny. I will try this out and let you know the outcome.
Thank you Sunny. I will try this out and let you know the outcome.
Yeah, let me know how you get on, and confirm if this is what you were looking for.
Hi Sunny,
I tried the below But, i am not able to get the results.
COUNT(CASE WHEN MATCH_ACTIVITIES ( "_CEL_O2C_ACTIVITIES"."ACTIVITY_EN" , NODE_ANY Y 'Create Billing Document/Invoice', 'Set Reason for Rejection' ] ) = 1 THEN 1 ELSE 0
'OR'
COUNT(CASE WHEN MATCH_ACTIVITIES ( "_CEL_O2C_ACTIVITIES"."ACTIVITY_EN" , NODE E'Cancel Reason for Rejection'])=0 THEN 0
ELSE 1 END)
think you have a syntax error. You may want to try the formula out in sections. I see that you are missing some brackets and END for the first CASE WHEN statement. Also "or " is an equaluator. So should have been used within the CASE WHEN. Think the below will work for you:
SUM(CASE WHEN MATCH_ACTIVITIES ( "_CEL_O2C_ACTIVITIES"."ACTIVITY_EN" , NODE_ANY [ 'Create Billing Document/Invoice', 'Set Reason for Rejection' ] ) = 1 THEN 1 ELSE 0 END)
+
SUM(CASE WHEN MATCH_ACTIVITIES ( "_CEL_O2C_ACTIVITIES"."ACTIVITY_EN" , NODE ['Cancel Reason for Rejection'])=0 THEN 0 ELSE 1 END)
Thank you so much Sunny. This worked
Thank you so much Sunny. This worked
not an issue. feel free to mark this question as answered.
Reply
Enter your E-mail address. We'll send you an e-mail with instructions to reset your password.