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!

Index This | I am a number, but when you add ‘G’ to me, I go away. What number am I?

March 2024 Edition Hayyy Splunk Education Enthusiasts and the Eternally Curious!  We’re back with another ...

What’s New in Splunk App for PCI Compliance 5.3.1?

The Splunk App for PCI Compliance allows customers to extend the power of their existing Splunk solution with ...

Extending Observability Content to Splunk Cloud

Register to join us !   In this Extending Observability Content to Splunk Cloud Tech Talk, you'll see how to ...