Dashboards & Visualizations

Choropleth Map, count by counties

dholz
Engager

Hello All,

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

dholz_0-1612368054450.png

Search:

sourcetype=*sourcetype* province=Pennsylvania
| stats latest(*stats*) as "*name*" by county
| geom nat_counties_lookup featureIdField=county

Labels (2)
0 Karma
1 Solution

dholz
Engager
0 Karma

dholz
Engager
0 Karma
Register for .conf21 Now! Go Vegas or Go Virtual!

How will you .conf21? You decide! Go in-person in Las Vegas, 10/18-10/21, or go online with .conf21 Virtual, 10/19-10/20.