Skip to main content
FILTER MATCH_ACTIVITIES ( ""."" , NODE [ 'Clear Invoice' ] ) = 0;

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