Splunk Search

Help generating a choropleth map using geom command

heavenisreal
Loves-to-Learn Lots

Hi There, 

I am trying to generate a choropleth map of US using the following command :
| iplocation final_ip
|search Country = "United States"
|stats count as volume by Region
|rename Region as state
|dedup state
|table state volume
|geom geo_us_states featureIdField="state" allFeatures=True

This gives a response with the fields state, volume, featureCollection, geom and but the map is still empty. Using geostats instead and then doing lookup, does give map but count aka volume is very low  . Can you help please ?

@

Labels (1)
0 Karma

heavenisreal
Loves-to-Learn Lots

Update::: Who knew, removing the  renaming of stats count as volume would do the trick! Is that expected ? Thanks nevertheless.

0 Karma

VatsalJagani
SplunkTrust
SplunkTrust

That's what I mentioned in my query.

Ha:)

0 Karma

VatsalJagani
SplunkTrust
SplunkTrust

@heavenisreal -Try updating query like this:

| iplocation final_ip
|search Country = "United States"
|stats count by Region
|rename Region as state
|geom geo_us_states featureIdField="state" allFeatures=True

 

I hope this helps!!!

0 Karma

heavenisreal
Loves-to-Learn Lots

Hi @VatsalJagani 

Thanks so much for your response. I tried out removing those lines as per your suggestion and it still doesn't render the map unfortunately. Do we need geostats for the map to render or should the geom just work as it is .

 

Regards,

 

0 Karma

VatsalJagani
SplunkTrust
SplunkTrust

@heavenisreal - geom should be enough, geostats is a different purpose.

 

To troubleshoot I would keep removing one line at a time from the search and see the statistics until I see the results in the statistics to see which line of search query has issue.

 

I hope this helps!!!

0 Karma
Get Updates on the Splunk Community!

What's new in Splunk Cloud Platform 9.1.2312?

Hi Splunky people! We are excited to share the newest updates in Splunk Cloud Platform 9.1.2312! Analysts can ...

What’s New in Splunk Security Essentials 3.8.0?

Splunk Security Essentials (SSE) is an app that can amplify the power of your existing Splunk Cloud Platform, ...

Let’s Get You Certified – Vegas-Style at .conf24

Are you ready to level up your Splunk game? Then, let’s get you certified live at .conf24 – our annual user ...