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

Reply