Is there a Group by function in quicksight?

[yuchen1]

Hi Quicksight users,

I need some help on a design. I want to create a percentage whose calculation is = Covid Population in the Country/Total Population in the Region. The example I shared, for US, it should be =10/(100+300) and for Canada, it should be 25/(100+300)

In SQL, I would use windows function or group by, anyone know how I can make it happen here?

[jose_burrull]

Hi @yuchen1 :

To reach the goal, you have to use aggregate functions … try this calculated field :

sumOver(sum({Population Got Covid}), [Country]) / sumOver(sum({Total Population}), [Region])

Regards, José Burrull