Question
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
01 Preview.jpg2156449 64 KB
02 result.jpg1383276 20.7 KB
+2Hello 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
If you have such a limit in place, can you please remove it (Limit Scrolling) to see if it works then?
Thanks and cheers
DavidEnter your E-mail address. We'll send you an e-mail with instructions to reset your password.