I'm working with county data in a narrow table format with a WKT column. To simplify, if the headers are id, geo_level, metric, metric_unit, and metric_value, some entries for the county with id 5 are:
5 | county | area | square km | 500
5 | county | pop_married | percent | .7
5 | county | total_pop | people | 4,000
5 | county | per_immigrant | percent | .04
5 | county | households | residences | 2,900
Each county has twenty-eight rows, one for each of the twenty-eight metrics I'm tracking across all counties. So when I load it as a delimited text layer, QGIS renders 28 polygons for each county, stacked exactly on top of one another.
I'd like to be able to visualize specific metrics for each county ("here's % married from county to county", "here's population from county to county"). But visualizing with categorized or graduated symbols in the layer properties doesn't work, because the values in the metric_values are all in different units.
Is there a way to specify what row you'd like the visualization to come from? Or to specify based on a specific string in the desired row?