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
-
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"0 -
Unfortunately an SQL solution won't help me in this case. It needs to be dynamically calculated in at the card level.
0
Categories
- 10.8K All Categories
- 3 Private Company Board
- 1 APAC User Group
- 12 Welcome
- 39 Domo News
- 9.7K Using Domo
- 1.9K Dataflows
- 2.5K Card Building
- 2.2K Ideas Exchange
- 1.2K Connectors
- 344 Workbench
- 260 Domo Best Practices
- 11 Domo Certification
- 467 Domo Developer
- 50 Domo Everywhere
- 106 Apps
- 717 New to Domo
- 85 Dojo
- Domopalooza
- 1.1K 日本支部
- 4 道場-日本支部へようこそ
- 27 お知らせ
- 64 Kowaza
- 299 仲間に相談
- 655 ひらめき共有