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!

How to Monitor Google Kubernetes Engine (GKE)

We’ve looked at how to integrate Kubernetes environments with Splunk Observability Cloud, but what about ...

Index This | How can you make 45 using only 4?

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

Splunk Education Goes to Washington | Splunk GovSummit 2024

If you’re in the Washington, D.C. area, this is your opportunity to take your career and Splunk skills to the ...