The data I have is a list of projects for which I have the following geographic information:
- longitude and latitude
- local authority
- region (or country, eg Wales)
as well as other details for each project.
I would like to create bubble map in Carto summing together project numbers according to UK local authorities and UK regions and countries.
So there should be one bubble for each local authority or region. For example using region: Northern Ireland would have the smallest bubble representing 71 projects and South East (England) would have the largest with 165 projects.
I tried to georeference the local authority and region but I get an error.
When I select the Bubble option from the wizard, the column drop down has only numerical values relating to each project. I can see no way of showing project numbers per "Admin Region".