How to calculate a ratio between two agregates inside a Group By?

Questions
1

Hi,
I’m trying to create a grouped dataset in Bubble where I group data by age and want to display a ratio of two aggregates on the chart.

My goal is to visualize this ratio on a chart — X-axis = AgeGroup, Y-axis = (Count / sum of GetSlot).

How to Generate a list of results of this two aggregates:
(CountAgeGroup 1 / SumAgeGroup1, CountAgeGroup2 / SumAgeGroup2, … ,Count AgeGroupN/ Sum AgeGroupN )

image
image352×571 19.7 KB

When I use it in the chat I can select only one of them

image
image493×210 7.13 KB

2

You can use the :formatted as text expression. Inside the formatter, do the math you need