Skip to main content
Hello all,
In the PQL Editor an output of my formula is shown in the preview. If I then go to Done and want to look at the table, I get the following error message could not find referenced aggregate COUNT(DISTINCT ). Can anyone help me?
I use the PQL formula: KMEANS() in its complex form.
Best Regards, Patrick

01 Preview.jpg2156449 64 KB

02 result.jpg1383276 20.7 KB
Hello Patrick,
welcome to the Celonis Community!
This is definitely we have to take a look at. I just tried to reproduce this behavior and I get the same error if I set a row limit in the component. Did you set a limit (similar to this:)?

If you have such a limit in place, can you please remove it (Limit Scrolling) to see if it works then?
Thanks and cheers
David
Hi David,
Thanks. That solved the issue.
Best Regards, Patrick