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)?

Thanks!

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 :

max(distinctCountOver({value_to_calculate_mod},[{dimension_for_grouping}],PRE_AGG))

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

max(distinctCountOver({product_sku},[{product_product_name}],PRE_AGG))

Hope it helps, otherwise let us know.

Happy dashboarding!