Skip to main content
Question

Error in Table while PQL Editor Preview shows results

  • October 16, 2019
  • 2 replies
  • 40 views
P
Level 2
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

2 replies

D
Level 1
Forum|alt.badge.img+2
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
P
Level 2
Hi David, Thanks. That solved the issue. Best Regards, Patrick
Community Code of ConductAccessibility statement