We need clarification on how QuickSight handles geographic data for Puerto Rico in map visualizations. We’ve found conflicting information in the documentation:
Hello @hprem
If I understand you my suggestion is:
Create a column called country and assign Puerto Rico to all rows. This way, will be recognised because, as I understand it, the default is the USA. When I applied the country column, it worked for my charts.
Since we have not heard back from you, I’ll go ahead and close/archive this topic. However, if you have any additional questions, feel free to create a new topic in the community and link this discussion for relevant information.
Hi @lary_andr, for my use case the dataset already contains a country column. My question was more around understanding if Puerto Rico would be treated as a territory of the United States or a separate Country on point maps, given the confusion from the documentation. As a workaround, I tested both approaches and found that QuickSight only displays Puerto Rico data points when:
Country is set as “United States”
Using standard US ZIP codes (00600-00999)
When setting Puerto Rico as a separate country, the map failed to render the data points.
Hi @hprem,
Thank you for sharing your findings. There are still some limitations with the QuickSight map visuals and I’ve seen a couple community posts regarding the use of Puerto Rico. I’ll mark this as a feature request to keep it on the support team’s radar when considering future feature fixes.