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.6K All Categories
- APAC User Group
- 12 Welcome
- 36 Domo News
- 9.6K Using Domo
- 1.9K Dataflows
- 2.4K Card Building
- 2.2K Ideas Exchange
- 1.2K Connectors
- 338 Workbench
- 250 Domo Best Practices
- 11 Domo Certification
- 460 Domo Developer
- 47 Domo Everywhere
- 100 Apps
- 703 New to Domo
- 84 Dojo
- Domopalooza
- 1.1K 日本支部
- 4 道場-日本支部へようこそ
- 22 お知らせ
- 62 Kowaza
- 295 仲間に相談
- 649 ひらめき共有