Altair RISE

A program to recognize and reward our most engaged community members

Nominate Yourself Now!

Choropleth Map Visualization Issue

While using the Choropleth visualization, I am running into an issue where the value used to display on the map is not the correct value (from the dataset) for a given country. For example, the happiness index score in the data for USA is 7.3, however, the map generated shows 4.3. The same issue seems to be happening with other numeric value columns displayed on the map as well.

Any idea why this may be happening?

Data and RapidMiner Process Link
https://drive.google.com/drive/folders/1mKTu-V5QmfYfHSB_YuLlULykeBMwjR4a?usp=sharing

Find more posts tagged with

AI Studio

Visualization + Dashboards

Accepted answers

Caperez

Hi @avd,

you need to Join your data by Country name,

regards.

Image: https://us.v-cdn.net/6030995/uploads/editor/zs/ea03lwocz7ca.png

Caperez

Hi @avd,

please see attached the process that I worked on.

I used the csv files as inputs.

regards

GDP Happiness Viz.rmp

Marco_Boeck

Hi,

You have two options to join: "Name" or the "ISO 3166" country/state codes. While the latter is more or less fixed by the ISO standard (usually 3166-1 alpha-2), the former is a bit subjective and depends on the map implementation. You can however see the name in the tooltip when hovering over the boundaries within the map, which is the exact name your data needs to contain when joining by "Name".

Regards,
Marco

All comments

Caperez

Hi @avd,

you need to Join your data by Country name,

regards.

amitd

While conceptually it makes sense, it does not work in my case. I've attached the image below. Any ideas, @ceaperez?

Image: https://us.v-cdn.net/6030995/uploads/editor/yx/gt1grmchd9la.png

Can you elaborate a bit on which table are we joining? Is it the geotable behind the map that is being joined? Is there a way to know the available attributes for this table being joined.

amitd

I figured out that the data contained "United States" instead of "United States of America", which caused the issue.

My earlier question though remains -
Can you elaborate a bit on which table are we joining? Is it the geotable behind the map that is being joined? Is there a way to know the available attributes for this table being joined.

Caperez

Hi @avd,

please see attached the process that I worked on.

I used the csv files as inputs.

regards

GDP Happiness Viz.rmp

Marco_Boeck