Error in Table while PQL Editor Preview shows results

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

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:)?

image

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