Using a Beast Mode Calculation in Summary Number
I created a simple beast mode calculation to calculate a ratio out of 2 other columns in my dataset. Is there any way to use this ratio in my Summary Number? The option is greyed out; I assume because it's not an aggregation?
Best Answers

you're correct. It has to be an aggregation for you to be able to use it as the Summary Number.
Domo Arigato!
**Say 'Thanks' by clicking the thumbs up in the post that helped you.
**Please mark the post that solves your problem as 'Accepted Solution'0 
so I assume your beastmode is something like: `column1`/`column2`? Next question is "average vacancy" if one building is 100% full and one is 50% full is the answer 75% (simple average) or is it a weighted (actual vacancy) based on size of building? I assume the second is preferable. Make the beastmode: Sum('column1')/Sum(`column2`) This should allow you to use it as a percentage in the summary number and it will work as a column calculation as well.Dojo Community Member
** Please like responses by clicking on the thumbs up
** Please Accept / check the answer that solved your problem / answered your question.3
Answers

you're correct. It has to be an aggregation for you to be able to use it as the Summary Number.
Domo Arigato!
**Say 'Thanks' by clicking the thumbs up in the post that helped you.
**Please mark the post that solves your problem as 'Accepted Solution'0 
There are ways to make it an aggregation depending on what you are trying to do. For example if Column 1 has three values: 1, 5 and 10 and Column two has three values of 1, 10 and 40 then I assume your besatmode is a calculation making percentages like: 100%, 50% and 25%? OR: are you making it something like 1:1, 5:10 and 10:40? in either case, you could create a beastmode that would let you show the calculation in the summary such as 31.3% or 16:51. what are you trying to accomplish?Dojo Community Member
** Please like responses by clicking on the thumbs up
** Please Accept / check the answer that solved your problem / answered your question.0 
Hi Shevy,
My beast mode calculation is just a percentage like you mentioned. My two columns represent the capacity of a building and the number of occupants, and the calculation is the % vacancy of the building.
It's represented as a percentage, which is how I want it, but it's not considered an aggregation so I can't use it in my Summary Number. What I would like to do is to show average vacancy for all buildings.
Armen
0 
so I assume your beastmode is something like: `column1`/`column2`? Next question is "average vacancy" if one building is 100% full and one is 50% full is the answer 75% (simple average) or is it a weighted (actual vacancy) based on size of building? I assume the second is preferable. Make the beastmode: Sum('column1')/Sum(`column2`) This should allow you to use it as a percentage in the summary number and it will work as a column calculation as well.Dojo Community Member
** Please like responses by clicking on the thumbs up
** Please Accept / check the answer that solved your problem / answered your question.3 
Thank you! This worked.
1
Categories
 All Categories
 1.1K Product Ideas
 1.1K Ideas Exchange
 1.2K Connect
 969 Connectors
 257 Workbench
 Cloud Amplifier
 1 Federated
 2.4K Transform
 76 SQL DataFlows
 501 Datasets
 1.8K Magic ETL
 2.7K Visualize
 2.2K Charting
 377 Beast Mode
 20 Variables
 486 Automate
 104 Apps
 378 APIs & Domo Developer
 6 Workflows
 22 Predict
 6 Jupyter Workspaces
 16 R & Python Tiles
 317 Distribute
 65 Domo Everywhere
 252 Scheduled Reports
 59 Manage
 59 Governance & Security
 1 Product Release Questions
 5K Community Forums
 37 Getting Started
 23 Community Member Introductions
 64 Community Announcements
 4.8K Archive