https://community.splunk.com/t5/Dashboards-Visualizations/Choropleth-Map-with-values-instead-of-count/m-p/206923#M43422 <P>Hi gokadroid, thanks for you answer, it's working <span class="lia-unicode-emoji" title=":slightly_smiling_face:">🙂</span></P> Thu, 03 Nov 2016 07:59:59 GMT bosch_softtec 2016-11-03T07:59:59Z https://community.splunk.com/t5/Dashboards-Visualizations/Choropleth-Map-with-values-instead-of-count/m-p/206921#M43420 <P>Hi,<BR /> I like to setup a choropleth map but I'm not able to build this map by the vales of a zone. I only got it working by counting the country's which results in value=1.</P> <P>My search looks like:</P> <PRE><CODE>| inputcsv Region.csv | join max=0 Region [inputcsv ISO_3166_Codes_Lat_Long.csv ] | stats count by Country | geom geo_countries featureIdField="Country" </CODE></PRE> <P>Region.csv file contains the country code and the number of clients. It looks like:</P> <PRE><CODE>Region,Number DE,51 GB,154 US,197 </CODE></PRE> <P>After the join I get all needed informations to setup the map but the result is:</P> <PRE><CODE>Country | count | ... Germany | 1 | ... United Kingdom | 1 | ... United States | 1 | ... </CODE></PRE> <P>I like to get:</P> <PRE><CODE>Country | count | ... Germany | 51 | ... United Kingdom | 154 | ... United States | 197 | ... </CODE></PRE> <P>I tried it with:</P> <PRE><CODE>| inputcsv Region.csv | join max=0 Region [inputcsv ISO_3166_Codes_Lat_Long.csv ] | stats values(Number) by Country | geom geo_countries </CODE></PRE> <P>But the map won't be coloured.</P> <P>Any idea how to solve this?</P> <P>Thank's for your ideas and help<BR /> Best regards<BR /> Thorsten</P> Wed, 02 Nov 2016 11:39:04 GMT https://community.splunk.com/t5/Dashboards-Visualizations/Choropleth-Map-with-values-instead-of-count/m-p/206921#M43420 bosch_softtec 2016-11-02T11:39:04Z https://community.splunk.com/t5/Dashboards-Visualizations/Choropleth-Map-with-values-instead-of-count/m-p/206922#M43421 <P>Since I don't have the data to plot similar stuff but If there is only one Number value per country you can you please try this and see if it works out:</P> <PRE><CODE>...| chart max(Number) by Country | geom geo_countries featureIdField="Country" </CODE></PRE> Wed, 02 Nov 2016 18:14:24 GMT https://community.splunk.com/t5/Dashboards-Visualizations/Choropleth-Map-with-values-instead-of-count/m-p/206922#M43421 gokadroid 2016-11-02T18:14:24Z https://community.splunk.com/t5/Dashboards-Visualizations/Choropleth-Map-with-values-instead-of-count/m-p/206923#M43422 <P>Hi gokadroid, thanks for you answer, it's working <span class="lia-unicode-emoji" title=":slightly_smiling_face:">🙂</span></P> Thu, 03 Nov 2016 07:59:59 GMT https://community.splunk.com/t5/Dashboards-Visualizations/Choropleth-Map-with-values-instead-of-count/m-p/206923#M43422 bosch_softtec 2016-11-03T07:59:59Z