Get most duplicate value (MODE)

Question & Answer
, ,
1

Is there a way to get the most frequent data?
I would like to check if Excel’s MODE function can be implemented on Quicksight.
For example,
when I have 1,2,2,3,3,3,4 data,
I want to get “3”.
Is there any way to do this?

2

I doesn’t seem like there is a native function for this which I am marking as a feature request.

However, what you can do is rank it by count and then filter just to the rank of 1

rank_field = rank

(
[count({field}) DESC]

)

2 Likes
3

I’m going to try the suggested solution, but I wish that. MODE was a function in Quicksight.