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.
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
Enter your E-mail address. We'll send you an e-mail with instructions to reset your password.