I'm a novice with Carto and GIS generally. I have a data table with a few thousand lines of data. Each row of data has a country and a numerical value.
I'm trying to total the value by country and show a single point per country.
I've tried reading documentation, but am overwhelmed by reading up on PostgreSQL - what I am attempting to do is so simple, yet I don't find a way of making it work.
Should I change my data structure - to only have one line of data per country? I would be surprised is that was necessary!
As you see in the map - the Netherlands has 3 or 4 overlapping circles - there should only be a single circle.
Edit: additional picture.