I am trying to visualize data in a choropleth map using shapefiles. My goal is to show a count of a field by county in PA. I have yet to find a well configured shapefile for all counties in PA, so I had to use one for the counties in all of the US. Unfortunately when I use the geom command this includes any other counties of the same name in the map vis. Is there a way to filter out other states and just include PA? or can I set bounds for this map so it only visualizes PA?
Image of Choropleth map as is
| stats latest(*stats*) as "*name*" by county
| geom nat_counties_lookup featureIdField=county