Change default setting for Mode calculations

[phoebe_kelley]

It would be helpful to be able to toggle the way the Mode calculation handles two or more "ties." Currently if there is a tie between records, the lower is returned. I have a use case where I would rather have the higher value return if there is a tie. I could also see there being a use for an average between the tied records. Ideally I think there would be three options for a tie: use the 1. lowest value 2. highest value 3. average of tied values. I'm not sure if first/last would also be helpful to have as options.

My use case is for product dimensions. We use the mode to normalize the dimensions (height, width, depth) of products. Because we are using the dimensions for space planning, if the lower value is used there may not be enough space for the product on the shelf. We would rather use the higher of the tied values to make sure we aren't creating a plan where the products won't fit.

[KylieF]

Thank you for your idea!

This is an interesting behavior, and it's great to hear a use case where you would be looking for the opposite. Since this would be a toggle in behavior our product team would greatly appreciate hearing from as many users as possible that would be interested in this change so be sure to share this idea if able!