# Create Region Map Visualization on Kibana with only Iso Code **URL:** \ **Category:** Kibana\ **Tags:** maps\ **Created:** [June 30, 2020, 6:52pm UTC](https://discuss.elastic.co/t/create-region-map-visualization-on-kibana-with-only-iso-code/239365 "2020-06-30T18:52:16Z")\ **Posts on this page:** 10\ **Page:** 1
**Author:** ![Fernando1](https://avatars.discourse-cdn.com/v4/letter/f/22d042/32.png) [@Fernando1](https://discuss.elastic.co/u/Fernando1)\ **Post date:** [June 30, 2020, 6:52pm UTC](https://discuss.elastic.co/t/create-region-map-visualization-on-kibana-with-only-iso-code/239365/1 "2020-06-30T18:52:16Z")
Hello!! How is going? I'm trying to build a Map visualization here in kibana. My data only has the iso 2 letters abbreviation code, and I want to do a "region" map, without points, because our data granularity doesn't need to be that specific for now. However, I'm struggling to find how may I do that on the new Maps section. I'm using Kibana latest version. And when adding a new layer, it says it can't find geospatial indexes, and by looking for the documentation I can only find for geopoint with lat and long. Can you help me, please? ---
**Author:** ![Nathan\_Reese](https://sea2.discourse-cdn.com/elastic/user_avatar/discuss.elastic.co/nathan_reese/32/84829_2.png) [@Nathan\_Reese](https://discuss.elastic.co/u/Nathan_Reese)\ **Post date:** [July 1, 2020, 2:57am UTC](https://discuss.elastic.co/t/create-region-map-visualization-on-kibana-with-only-iso-code/239365/2 "2020-07-01T02:57:52Z")
Follow [this documentation](https://www.elastic.co/guide/en/kibana/current/maps-add-choropleth-layer.html) for creating a region map. ---
**Author:** ![Fernando1](https://avatars.discourse-cdn.com/v4/letter/f/22d042/32.png) [@Fernando1](https://discuss.elastic.co/u/Fernando1)\ **Post date:** [July 1, 2020, 6:31pm UTC](https://discuss.elastic.co/t/create-region-map-visualization-on-kibana-with-only-iso-code/239365/3 "2020-07-01T18:31:15Z")
Thanks, Nathan for the answer!! However, I've tried it here and still hasn't loaded the map. How should be the right index? In my case is a string keyword for the two letters abbreviation, e.g.: Brazil -\> "BR", or USA -\> "US". Should I map it as another type other than string? ---
**Author:** ![Nathan\_Reese](https://sea2.discourse-cdn.com/elastic/user_avatar/discuss.elastic.co/nathan_reese/32/84829_2.png) [@Nathan\_Reese](https://discuss.elastic.co/u/Nathan_Reese)\ **Post date:** [July 1, 2020, 7:01pm UTC](https://discuss.elastic.co/t/create-region-map-visualization-on-kibana-with-only-iso-code/239365/4 "2020-07-01T19:01:05Z")
What does your layer configuration look like? ---
**Author:** ![Fernando1](https://avatars.discourse-cdn.com/v4/letter/f/22d042/32.png) [@Fernando1](https://discuss.elastic.co/u/Fernando1)\ **Post date:** [July 1, 2020, 7:05pm UTC](https://discuss.elastic.co/t/create-region-map-visualization-on-kibana-with-only-iso-code/239365/5 "2020-07-01T19:05:36Z")
Here how it is set up: ![image](https://us1.discourse-cdn.com/elastic/original/3X/7/1/71b1a6e740b6347ec6a2d9c83e4122741075c742.png) ---
**Author:** ![Nathan\_Reese](https://sea2.discourse-cdn.com/elastic/user_avatar/discuss.elastic.co/nathan_reese/32/84829_2.png) [@Nathan\_Reese](https://discuss.elastic.co/u/Nathan_Reese)\ **Post date:** [July 1, 2020, 7:22pm UTC](https://discuss.elastic.co/t/create-region-map-visualization-on-kibana-with-only-iso-code/239365/6 "2020-07-01T19:22:19Z")
What is returned in the response for the join request under [inspector adaptors](https://www.elastic.co/guide/en/kibana/current/maps-troubleshooting.html#_inspect_elasticsearch_requests)? ---
**Author:** ![Fernando1](https://avatars.discourse-cdn.com/v4/letter/f/22d042/32.png) [@Fernando1](https://discuss.elastic.co/u/Fernando1)\ **Post date:** [July 1, 2020, 7:25pm UTC](https://discuss.elastic.co/t/create-region-map-visualization-on-kibana-with-only-iso-code/239365/7 "2020-07-01T19:25:48Z")
![image](https://us1.discourse-cdn.com/elastic/original/3X/2/d/2d0fb89cd80cae15e803bf3a1cc2597e155ed3d6.png) Request: ```auto { "size": 0, "aggs": { "join": { "terms": { "field": "country_abbrev.keyword", "order": { "_count": "desc" }, "size": 10000 }, "aggs": { " __kbnjoin__ avg_of_document_balance_usd_groupby_war_geo_complete_index.country_abbrev.keyword": { "avg": { "field": "document_balance_usd" } } } } }, "stored_fields": [ "*" ], "script_fields": {}, "docvalue_fields": [ { "field": "@timestamp", "format": "date_time" }, { "field": "entry_date", "format": "date_time" }, { "field": "issue_date", "format": "date_time" }, { "field": "settled_date", "format": "date_time" } ], "_source": { "excludes": [] }, "query": { "bool": { "must": [], "filter": [ { "match_all": {} }, { "range": { "issue_date": { "gte": "2020-07-01T17:54:26.867Z", "lte": "2020-07-01T18:09:26.867Z", "format": "strict_date_optional_time" } } } ], "should": [], "must_not": [] } } } ``` Response: ```auto { "took": 4, "timed_out": false, "_shards": { "total": 1, "successful": 1, "skipped": 0, "failed": 0 }, "hits": { "total": 0, "max_score": null, "hits": [] }, "aggregations": { "join": { "doc_count_error_upper_bound": 0, "sum_other_doc_count": 0, "buckets": [] } } } ``` ---
**Author:** ![Nathan\_Reese](https://sea2.discourse-cdn.com/elastic/user_avatar/discuss.elastic.co/nathan_reese/32/84829_2.png) [@Nathan\_Reese](https://discuss.elastic.co/u/Nathan_Reese)\ **Post date:** [July 1, 2020, 7:43pm UTC](https://discuss.elastic.co/t/create-region-map-visualization-on-kibana-with-only-iso-code/239365/8 "2020-07-01T19:43:26Z")
It looks like there are no matching documents. Does your right index have a default time field? Does kibana's global time picker match the time range for any of your data? Go to discover and view your right side index. What time range do you need to show data? Use that time range in the maps app. ---
**Author:** ![Fernando1](https://avatars.discourse-cdn.com/v4/letter/f/22d042/32.png) [@Fernando1](https://discuss.elastic.co/u/Fernando1)\ **Post date:** [July 1, 2020, 8:40pm UTC](https://discuss.elastic.co/t/create-region-map-visualization-on-kibana-with-only-iso-code/239365/9 "2020-07-01T20:40:08Z")
Hahahah it was the time picker!!! Every now and then I'm caught on this hahahaha Thanks it is working now!!! ---
**Author:** ![system](https://us1.discourse-cdn.com/elastic/original/3X/1/a/1ac57faf039f6b580b3f104ef42a2a89e41014de.png) [@system](https://discuss.elastic.co/u/system)\ **Post date:** [July 29, 2020, 8:40pm UTC](https://discuss.elastic.co/t/create-region-map-visualization-on-kibana-with-only-iso-code/239365/10 "2020-07-29T20:40:08Z")
This topic was automatically closed 28 days after the last reply. New replies are no longer allowed.