Unlock a world of possibilities! Login now and discover the exclusive benefits awaiting you.
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
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>))
Hello Sangram,
I tried this and still not working
Regards,
Gerd Neumann
Hi @reddy-s I am also experiencing the same issue, please assist me with a solution, thanks in advance.