How can I calculate Mode (the most common value) in QuickSight?

Hi, I can see median, mean, percentiles and std deviation. But is there a way to calculate MODE (most common value)?


Hello @Eleri , thanks for your question.

I understand that you want to calculate the MODE using Quicksight.

In this case you will need to create a calculated field and use a combination of distinctCountOver and max functions :


For example to count the mod accross the SKUs of AWS services in cost and usage report you can use:


Hope it helps, otherwise let us know.

Happy dashboarding!