How can I normalize my numeric values in Builder?
When preparing polygon data layers in CARTO, normalize your data is a good cartographic method in order to create meaningul visualizations. CARTO users can normalize raw data by area, by total (like population) or by other thematic value.
For instance, in order to normalize a column value by its area, it would be necessary to apply a SQL query similar to this one, thus using
ST_Area PostGIS function:
SELECT *, numeric_column/ST_Area(the_geom) as norm_column FROM table