Skip to main content
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. 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, 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
Community Code of ConductAccessibility statement