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?
Thats the limitation of the MODE function. When the occurrence of two values is the same a NULL is returned.
Try this function instead:
I tried this and still not working
Retrieving data ...