Selection based on an attribute of a specific activity, while ignoring the same attribute of other activities

I need to filter my analysis by a specific value of a specific activity attribute.

I.e. I want to only show cases when the attribute CHANGED_FROM of an activity “change quantity” is <1.

The point is that other activities also have this same attribute, but these cases are not relevant for my goal.

thank you very much in advance for the advice!

Hello Masha,

Thanks for reaching out! If I understand you correctly, two conditions need to be satisfied (specific activity and specific value). The logical AND operator should solve the problem. Simply concatenate both conditions in your filter statement with AND. Only if both conditions are met, cases are included.

Example:

FILTER "_CEL_PROCESS_ACTIVITIES"."ACTIVITY_EN" = 'Change Quantity' AND "_CEL_PROCESS_ACTIVITIES"."CHANGED_FROM" < 1;

I hope this formula and the explanation help solving your problem.