Is it possible to calculate Mode in a Beast Mode?

swagner

I've got a histogram card that is showing unit costs for items, and I want to display the most commonly applied cost (Mode) in the summary number.  How would this be accomplised in a beast mode?

 

Definition:  Mode is the value that occurs most frequently in a given set of data.

 

by the way... try searching for "Mode" in the Dojo...

AS

Lol your last line.

 

I'm unaware of a function for mode.  I think you'd need a dataflow for that, unfortunately.

 

This, and lots of other articles online, provide some alternatives to standard functions.

http://blogs.lessthandot.com/index.php/DataMgmt/DataDesign/calculating-mean-median-and-mode-with-sq/

 

 

swagner

Unfortunately an SQL solution won't help me in this case.  It needs to be dynamically calculated in at the card level.