Hi everyone,
I’m working on an analysis in Celonis and I have a question regarding filtering table rows.
In my case, one of the columns in my table displays a sum of values retrieved from the backend (e.g., SUM("SomeColumn")). I would like to exclude all rows where this sum equals zero, so they don’t appear in the final table.
How can I apply such a filter directly in the table configuration or via a filter condition?
Thanks in advance for your help!
Hi Yannick,
To filter out rows in your Celonis table where a summed column like SUM("SomeColumn") equals zero, you should apply a PQL filter. The most common method involves navigating to the "Filters" section within your analysis, clicking "Add Filter," and then entering the PQL condition SUM("SomeColumn") != 0. This condition directly tells Celonis to only include rows where the sum of "SomeColumn" is not zero, thereby excluding all rows that result in a zero sum. Alternatively, you can apply the exact same SUM("SomeColumn") != 0 PQL condition directly within the "Configuration" panel of your specific table component under its "Filters" or "Component Filters" section, achieving the same result of removing those zero-sum rows from your final table display. Hope it helps!
Enter your E-mail address. We'll send you an e-mail with instructions to reset your password.