Some MAP DATA not rendered

Question & Answer
,
1

image

I have added country as the hierarchy

The issue is Iam getting some MAP data not rendered

2

@Koushik_Muthanna or @ErikG – Please review this

3

Hello Deepa,

Geospatial data can’t contain ambiguous locations. For example, suppose that the data contains a city named Springfield, but the next level in the hierarchy is country. Because multiple states have a city named Springfield, it isn’t possible to geocode the location to a specific point on a map.

To avoid this problem, you can add enough geographical data to indicate what location should show on a map chart. For example, you can add a state level into your data and its hierarchy. Or, you might add latitude and longitude

fore more info see - Geospatial troubleshooting - Amazon QuickSight

Alternatively, if it still does not work. I would recommend to file a support case with AWS Support
Hope fully the support engineer can solve the issue.

Hope this helps.
Cheers,
Deep

4

Hey @Deep -

I tried doing it your way I added State CITY and ZIP and country , Since Bogota is a city and state both in Columbia i was getting this issue , Hence i just added one hierarchy still same .

5

Hello Deepa,

Did you try with adding latitude and longitude… see if that helps? if not reach out to support.

Cheers,
Deep

6

What if we dont have latitude and longitude

7

Hello Deepa,

As suggested , please reach out to support may be support engineer has some workaround.

I tried to search similar problem but one approach i found was joining the data set for Lat & Long. Yes its not supported yet but kind of work around seems to exist.

I have not tried myself to confirm. but may be you could try if this helps.

Link here - amazon web services - QuickSight "Geographical fields aren't supported in joins between data sources" - Stack Overflow

Hope this helps.
Cheers,
Deep