Hi @laura,
as far as I understand, you want to apply a component filter that filters out all cases with less than 5 activities. You have to use PU_COUNT to do that. The formula would look as follows:

FILTER CASE
WHEN PU_COUNT ( CASE TABE, ACTIVITIES TABLE.ACTIVITY COLUMN ) >= 5
THEN >= 5 Activities per Case
ELSE < 5 Activities per Case
END
= >= 5 Activities per Case

Hopefully, thatll solve your issue! Otherwise, feel free to reach out to us again!
Best regards,
Justin

---

Hi Justin,
It is not working:


For precision, I am on Celons 4.5.
Laura

---

Hi @laura,
you have to use PU Functions for both filters. Otherwise you operate on the item level for first filter and on the case level for the second filter. You should use PU_COUNT in the first filter.
It is supposed to work as follows:
Filter 1:

FILTER PU_COUNT ( Case Table, Activity Table.Activity Column, Activity Table.Activity Column IN (Your Activity) ) > 0;

Filter 2:

FILTER CASE
WHEN PU_COUNT ( Case Table, Activity Table.Activity Column ) >= 5
THEN >= 5 Activities per Case
ELSE < 5 Activities per Case
END
= >= 5 Activities per Case;

I assume thatll solve your issue. Otherwise, feel free to reach out to us again!
Best,
Justin

---