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?
you're correct. It has to be an aggregation for you to be able to use it as the Summary Number.
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.
Thank you! This worked.
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%.