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

Comments

  • AS
    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/

     

     

    Aaron
    MajorDomo @ Merit Medical

    **Say "Thanks" by clicking the heart in the post that helped you.
    **Please mark the post that solves your problem by clicking on "Accept as Solution"
  • Unfortunately an SQL solution won't help me in this case.  It needs to be dynamically calculated in at the card level.