Skip to main content
Hi Folks, I have a use case where it would be easiest solution to use COUNT Statement within the FILTER? However it is not possible. Do you have some tips for me? Thanks. B.

Could you give more details about the logic behind the filter? Why is a COUNT needed?


Unfortunately you cannot filter on a COUNT. You would have to use PU_COUNT instead.

 

Remember that you can filter on cases only. Using COUNT would convert the result into a KPI (single value). This can be used in tables to show count per case. But not in a filter. For filters you need to explicitly classify which cases need to be filtered. For this use PU_COUNT.

 

https://docs.celonis.com/en/pull-up-aggregation.html


Could you give more details about the logic behind the filter? Why is a COUNT needed?

Thanks for the reaction. Well, what I am trying to create condition to identify the duplicate values. To do so I am concatenating few fields/conditions and simply count them. If all those conditions are met and after counting there will be more than one concatenated value, then it is duplicate for me.


Unfortunately you cannot filter on a COUNT. You would have to use PU_COUNT instead.

 

Remember that you can filter on cases only. Using COUNT would convert the result into a KPI (single value). This can be used in tables to show count per case. But not in a filter. For filters you need to explicitly classify which cases need to be filtered. For this use PU_COUNT.

 

https://docs.celonis.com/en/pull-up-aggregation.html

Thanks for the hint. I managed to get what I wanted partly by applying the FILTER PU_COUNT(DOMAIN_TABLE())..etc. condition. Let's me try applying few more ideas if they will somehow help.


Reply