# 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!

Tagged:

• 🔵

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`)

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.

• 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!!!