Comparing aggregate data with benchmark data


I manage a dataset in elastic that stores records of grants allocated across the UK for a charity. There is a need to aggregate the data into regions and then compare that allocation ratios to population statistics. The query to aggregate grants by region is quite simple of course. But I cannot think of a way to then compare this to the target percentages by region.

The regional data is a static dataset that is updated monthly, and comprises of a small table of region names and % of population within the region.

Any suggestions on how I can prepare a bar that shows two bars per region, one the sum of grants awarded and the other the population? Do I need to store the population data on each and every grant record to achieve this?

This topic was automatically closed 28 days after the last reply. New replies are no longer allowed.