Is it possible to calculate Mode in a Beast Mode?

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

Find more posts tagged with

Comments

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.

Quick Links

All Categories
Recent Posts
Activity
Unanswered
Groups
Best Of