How to have a static number in beast mode
I have a table of categories with corresponding category path and visitors. Like the table below:
ID | Category Name | Category Path | Visitors | % Seg |
123 | A Airlines | Travel and Tourism -> In-Market -> Airlines | 1000 | 100/10000 |
124 | B Airlines | Travel and Tourism -> In-Market -> Airlines | 1500 | 1500/10000 |
125 | C Airlines | Travel and Tourism -> In-Market -> Airlines | 2000 | 2000/10000 |
126 | D Airlines | Travel and Tourism -> In-Market -> Airlines | 2500 | 2500/10000 |
200 | In-Market | Travel and Tourism | 10000 |
I need to create a "% of Segment" beast mode, whose calculation is Visitor (for each airline)/ Visitor (In-market), so I need my denominator to be static - 100000 - in the beast mode. The beast mode I'm having right now is `Visitor`/(case when `ID`=200 then `Visitor` end), which doesn't work. How can I have that number other than manually typing in?
Thank you for any idea on how to solve it!
Comments
-
You'd need, at the very minimum, a window function for that kind of math. I don't think these are officially supported by Domo for Beast Modes (they are in data flows), so your mileage may vary.
To get your denominator it would be something like sum(`visitors`) over (partition by `category path`)
Help link: https://dev.mysql.com/doc/refman/8.0/en/window-functions-usage.html
You appear to have the added complexity of extracting category values from your category path column, so that may make things more difficult if you want to get those exact elements as shown here.
Hopefully this gives you some direction. Let us know if you need more help.
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"1 -
Hi Aaron,
Thank you for the idea! However, the visitor for "In-Market" is not the sum of other rows, which is why I need to use that exact cell value, so I don't think I can use the function you suggested.
The reason why I didn't do these calculations in data flows is because the denominators for the different categories vary, which depend on the categories filtered in the cards. If there is no available function in beast modes, I will just manully type in. Thank you!!!
0
Categories
- 11K All Categories
- 5 Private Company Board
- 2 APAC User Group
- 12 Welcome
- 42 Domo News
- 9.9K Using Domo
- 2K Dataflows
- 2.5K Card Building
- 2.2K Ideas Exchange
- 1.2K Connectors
- 349 Workbench
- 267 Domo Best Practices
- 12 Domo Certification
- 474 Domo Developer
- 51 Domo Everywhere
- 110 Apps
- 726 New to Domo
- 85 Dojo
- Domopalooza
- 1.1K 日本支部
- 4 道場-日本支部へようこそ
- 29 お知らせ
- 65 Kowaza
- 302 仲間に相談
- 664 ひらめき共有