Hi everyone,
Is there a way to find out the value that appears most often in the dataset?
I could not find it in PQL references.
Example Values in a Dataset
2
2
2
10
3
5
In this example, the value 2 appears most often.
Looking forward to your replies.
Many thanks and best regards,
Thorsten
+2Hi Thorsten,
you can easily search for PQL functions by clicking on the toggle button on the right-side. In this case MODE(column) should bring the expected outcome
See more:
celonis.cloud/help/display/CIBC/MODE
Enter your E-mail address. We'll send you an e-mail with instructions to reset your password.