Are you a member of the Splunk Community?
- Find Answers
- :
- Using Splunk
- :
- Dashboards & Visualizations
- :
- How to plot choropleth map from a csv file? No int...
- Subscribe to RSS Feed
- Mark Topic as New
- Mark Topic as Read
- Float this Topic for Current User
- Bookmark Topic
- Subscribe to Topic
- Mute Topic
- Printer Friendly Page
- Mark as New
- Bookmark Message
- Subscribe to Message
- Mute Message
- Subscribe to RSS Feed
- Permalink
- Report Inappropriate Content
Bonjour,
I am using a csv file with 3 columns, let's name it ct.csv, it looks like this:
Country or entitie, Indice1, indice2
France, 11,12
Canada,41,44
Kosovo,78,56
Hong Kong,32,87
........
I have applications Search and report, google maps and Lookup Editor on my splunk, the problem is my VM of my company has no internet connection, which means I cannot use google map application, so what can I do for plot a choropleth map from a csv file? Thanks
- Mark as New
- Bookmark Message
- Subscribe to Message
- Mute Message
- Subscribe to RSS Feed
- Permalink
- Report Inappropriate Content
run anywhere example...
| makeresults
| eval count=25
| eval Country="France!!!Kosovo!!!United States!!!Canada!!!Hong Kong"
| makemv delim="!!!" Country
| mvexpand Country
| geom geo_countries featureIdField=Country
You have to zoom and scroll as appropriate to be able to see Kosovo and Hong Kong, but they are there.
- Mark as New
- Bookmark Message
- Subscribe to Message
- Mute Message
- Subscribe to RSS Feed
- Permalink
- Report Inappropriate Content
run anywhere example...
| makeresults
| eval count=25
| eval Country="France!!!Kosovo!!!United States!!!Canada!!!Hong Kong"
| makemv delim="!!!" Country
| mvexpand Country
| geom geo_countries featureIdField=Country
You have to zoom and scroll as appropriate to be able to see Kosovo and Hong Kong, but they are there.
- Mark as New
- Bookmark Message
- Subscribe to Message
- Mute Message
- Subscribe to RSS Feed
- Permalink
- Report Inappropriate Content
Can you use KMZ files?
https://www.splunk.com/blog/2015/10/01/use-custom-polygons-in-your-choropleth-maps.html
- Mark as New
- Bookmark Message
- Subscribe to Message
- Mute Message
- Subscribe to RSS Feed
- Permalink
- Report Inappropriate Content
Yes, I thought the basic splunk installation came with a couple of geo files for this.
Not sure if Kosovo or Hong Kong are considered a "country" in the basic geo files, though.
Splunkbase Unveils New App Listing Management Public Preview
Leveraging Automated Threat Analysis Across the Splunk Ecosystem
Can’t Make It to Boston? Stream .conf25 and Learn with Haya Husain
