Trouble with mode function

[#1]

Hello,

I have a problem with mode function (moda (minutos)) in order to find the most occurring value displayed in a KPI.

The problem is when different values are occurring the same amount of times, then null is retrieved.

What alternatives i have to fix the problem?

King Regards

Gerd Neumann

[reddy-s]

Hi Gerd,

Thats the limitation of the MODE function. When the occurrence of two values is the same a NULL is returned.

Try this function instead:

max(aggr(count(<Field>),<Field>))

[#3]

Hello Sangram,

I tried this and still not working

Regards,

Gerd Neumann

[Thabang231]

Hi @reddy-s  I am also experiencing the same issue, please assist me with a solution, thanks in advance.