If you’re looking to view country names in your map charts when you hover over a country, you will need to change your country column to only use full country names.
If this country naming convention isn’t possible on your database directly, two options are possible in Chartio.
- If you’d like this option in numerous charts, you can create a custom column with a case statement changing all the country codes to full country names. You would then use this custom column in your interactive mode queries where you’re looking to create map charts.
- Create a case statement in the data pipeline changing the country codes to full country names such as: CASE WHEN “Country” = ‘AU’ THEN ‘Australia’ WHEN “Country” = ‘US’ THEN ‘United States’ ELSE “Country” END
Note: that this will have to be done for all countries in your column for it be applied on your chart.
Once your case statement is completed, make sure to change your Area code/name to “Name” in the chart settings to recognize your new country names.
You final chart will now show both the name of the country you’re hovering over as well as the measure values.