Calculation of MODE in Anaplan
Does anyone know how to obtain the MODE of a set of values (in Anaplan)?
For example, lets say I have a list of employees and each employee has a salary. I'd like to find the salary that occurs most often in a group (i.e. the MODE). Working with MODE in Excel, there will be times when a MODE value doesn't exist (because all of the values are unique). Our use-case frequently has recurring values, so we want a way to dynamically find them. I considered using a list to set the values from (because then we could get a count of how many times each list item is used), but that probably won't scale well and seems a little silly.