Is it possible to calculate Mode in a Beast Mode?

swagner Contributor

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

    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.



    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"
  • swagner
    swagner Contributor

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