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