Forum Discussion

HannahWright2's avatar
HannahWright2
Qrew Trainee
4 years ago

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

1 Reply

  • I have access to a JavaScript programmer if you have a bit of a budget.  I agree that there is not a native way to get the mode.

    ------------------------------
    Mark Shnier (YQC)
    Quick Base Solution Provider
    Your Quick Base Coach
    http://QuickBaseCoach.com
    mark.shnier@gmail.com
    ------------------------------