Using a Beast Mode Calculation in Summary Number

user0010188

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?

Godzilla

you're correct. It has to be an aggregation for you to be able to use it as the Summary Number. 

Shevy

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.

Godzilla

you're correct. It has to be an aggregation for you to be able to use it as the Summary Number. 

Shevy

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?

user0010188

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

Shevy

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.

user0010188

Thank you!  This worked.

user02163

Hi @Shevy , 

What would I do to show the highest ratio in the summary? In your ex above, I'd want the summary to show 100%.

 

Thanks!