Hi Andreas,
Welcome to the Celonis Community
I afraid it is not possible to use a sheet filter for this as sheet filter always exclude cases.
Im not sure in which situations these activities being included bother you. But here are a few Ideas I could think of.
If you dont want the want the variant / Process explorer to show these activities, you can use the eye icon to hide them from view.
If you want to exclude them from activity counts, there are two ways to do this.
- If you have a farely small number of activities you want to exclude the easiest way to is to use REMAP_VALUES.
COUNT( REMAP_VALUES(activity table.activity column, [activity to exclude 1,NULL], [ activity to exclude 2,NULL], [ activity to exclude 3,NULL], ))
- If you have more activities you want to exclude and some of them follow a certain rule (e.g. no activities performed by batch users) you could use a CASE WHEN statement to to this.
COUNT( CASE WHEN activity table.user type != batch user type AND activity table.activity column NOT IN (activity to exclude1,activity to exclude2, activity to exclude3,)
THEN activity table.activity column
ELSE NULL
END)
I know this code is a little complicated, so Ill explain it quickly. COUNT counts the number of non-NULL values so when the condition that the activity has neither a batch user nor is it in the list of band activities, it gets some non-NULL value. Im using the activity name for this, but it doesnt really matter what is used so long as its guaranteed not to have any unexpected missing values. The important part of the code is that, if the condition is fulfilled (i.e. the activity is one you want to exclude) it is a signed the value written after ELSE, which is in this case NULL so its not counted.
I hope this answers your questions. If these suggestions dont cover what you want to achieve then please write back with more details. Its frequently helpful if to use screenshots when explaining your aim.
Best wishes,
Calandra