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 (1)
0 Karma
1 Solution

dholz
Engager
0 Karma

dholz
Engager

Solved using this blog to make my own kml file using a shapefile: https://www.splunk.com/en_us/blog/tips-and-tricks/use-custom-polygons-in-your-choropleth-maps.html 

0 Karma
Career Survey
First 500 qualified respondents will receive a $20 gift card! Tell us about your professional Splunk journey.

Can’t make it to .conf25? Join us online!

Get Updates on the Splunk Community!

Can’t Make It to Boston? Stream .conf25 and Learn with Haya Husain

Boston may be buzzing this September with Splunk University and .conf25, but you don’t have to pack a bag to ...

Splunk Lantern’s Guide to The Most Popular .conf25 Sessions

Splunk Lantern is a Splunk customer success center that provides advice from Splunk experts on valuable data ...

Unlock What’s Next: The Splunk Cloud Platform at .conf25

In just a few days, Boston will be buzzing as the Splunk team and thousands of community members come together ...