Filter component count

Hello everyone,

I would like to filter a table where COUNT(ACTIVITIES) >=5 but the filter load give me errore.
I also tried directly in the KPI :
CASE WHEN
COUNT(“INCIDENT_ACTIVITIES”.“ACTIVITY_EN”) >=5
THEN COUNT(“INCIDENT_ACTIVITIES”.“ACTIVITY_EN”)
ELSE NULL
END

But in the table I have the line with “NULL” I do not want.
image

Thanks

Laura

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, that’ll solve your issue! Otherwise, feel free to reach out to us again!

Best regards,

Justin

Hi Justin,

It is not working:
image
image

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 that’ll solve your issue. Otherwise, feel free to reach out to us again!

Best,

Justin