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

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
Get Updates on the Splunk Community!

Let’s Talk Terraform

If you’re beyond the first-weeks-of-a-startup stage, chances are your application’s architecture is pretty ...

Cloud Platform | Customer Change Announcement: Email Notification is Available For ...

The Notification Team is migrating our email service provider. As the rollout progresses, Splunk has enabled ...

Save the Date: GovSummit Returns Wednesday, December 11th!

Hey there, Splunk Community! Exciting news: Splunk’s GovSummit 2024 is returning to Washington, D.C. on ...