Skip to main content

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

 

Hi 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

MODESee more:

celonis.cloud/help/display/CIBC/MODE


Reply