I have a layer with polygons that have smaller areas within. Think counties/municipalities within a state.
The 3 fields in my table are STATE, MUNICIPALITY and a NUMERIC VALUE within the municipality (from 0 to 1) that needs to be mapped.
The problem is that the Quantiles are calculated from all the values in the table (22k) and I need them to be calculated and displayed by STATE, so every state need to have the 5 quantile classes within them.
How can I achieve this without having to create a separate layer by STATE (120)?
I tried some sort of normalization, but my STATE value is text and therefore not usable...