Hi, I can see median, mean, percentiles and std deviation. But is there a way to calculate MODE (most common value)?
Thanks!
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!