HannahWright2
5 years agoQrew Trainee
Quick Base Fomula to find Mode of an Array
Hi there,
I'm trying to figure out how I can determine the mode of an array of numbers using a Quick Base formula. From what I've found, Quick Base has formulas for finding the mean, and median but not the mode. I was considering using javascript in one of my formula fields but have very minimal javascript exposure. Does anyone know how I would find the mode natively or in javascript using a Quick Base formula field?
Any help is greatly appreciated!
------------------------------
Hannah Wright
------------------------------
I'm trying to figure out how I can determine the mode of an array of numbers using a Quick Base formula. From what I've found, Quick Base has formulas for finding the mean, and median but not the mode. I was considering using javascript in one of my formula fields but have very minimal javascript exposure. Does anyone know how I would find the mode natively or in javascript using a Quick Base formula field?
Any help is greatly appreciated!
------------------------------
Hannah Wright
------------------------------