Map chart now working


I have records as below
Opportunity_ID as 1,2,3,4,5,…
Country as India,China,…
Country_ID as IN,CH,…

I am trying to plot count by country on map. Tried with both Country and Country_ID. It doesn’t highlight on the map. It shows the map but no country is highlighted.


Please post “Diagnostic Info” from Admin > Troubleshooting.

If Country_ID is following ISO-3166 A2, and you’re setting that as you “Region field” in the visualization settings, then it should work with the built-in World region map.
A2 for China is CN

Otherwise you need to provide steps-to-reproduce and screenshots.

Hi Flamber,

thanks for the reply. Yes I am using that list. Attaching the excel. Sorry I was lousy in typing wrong code for china. Here is the screenshot as well.

Andorra AD
United Arab Emirates AE
Afghanistan AF
Antigua and Barbuda AG
Anguilla AI
Albania AL
Armenia AM
Angola AO
Antarctica AQ
Argentina AR
American Samoa AS
Austria AT
Australia AU
Aruba AW
Åland Islands AX
Azerbaijan AZ
Bosnia and Herzegovina BA
Barbados BB
Bangladesh BD
Belgium BE
Burkina BF
Bulgaria BG
Bahrain BH
Burundi BI
Benin BJ
Saint Barthélemy BL
Bermuda BM
Brunei BN
Bolivia BO
Bonaire BQ
Brazil BR
Bahamas BS
Bhutan BT
Bouvet Island BV
Botswana BW
Belarus BY
Belize BZ
Canada CA
Cocos (Keeling) Islands CC
Democratic Republic of the Congo CD
Central African Republic CF
Congo CG
Switzerland CH
Ivory Coast CI
Cook Islands CK
Chile CL
Cameroon CM
China CN
Colombia CO
Costa CR
Cuba CU
Cabo Verde CV
Curaçao CW
Christmas Island CX
Cyprus CY
Czech Republic CZ
Germany DE
Djibouti DJ
Denmark DK
Dominica DM
Dominican Republic DO
Algeria DZ
Ecuador EC
Estonia EE
Egypt EG
Western Sahara EH
Eritrea ER
Spain ES
Ethiopia ET
Finland FI
Fiji FJ
Falkland Islands FK
Micronesia (Federated States of) FM
Faroe FO
France FR
Gabon GA
United Kingdom of Great Britain and Northern Ireland GB
Grenada GD
Georgia GE
French Guiana GF
Guernsey GG
Ghana GH
Gibraltar GI
Greenland GL
Gambia GM
Guinea GN
Guadeloupe GP
Equatorial Guinea GQ
Greece GR
South Georgia and the South Sandwich Islands GS
Guatemala GT
Guam GU
Guinea-Bissau GW
Guyana GY
Hong HK
Heard Island and McDonald Islands HM
Honduras HN
Croatia HR
Haiti HT
Hungary HU
Indonesia ID
Ireland IE
Israel IL
Isle of Man IM
India IN
British Indian Ocean Territory IO
Iraq IQ
Iran IR
Iceland IS
Italy IT
Jersey JE
Jamaica JM
Jordan JO
Japan JP
Kenya KE
Kyrgyzstan KG
Cambodia KH
Kiribati KI
Comoros Kitts and Nevis KM
Saint KN
North Korea KP
South Korea KR
Kuwait KW
Cayman Islands KY
Kazakhstan KZ
Laos LA
Lebanon LB
Saint Lucia LC
Liechtenstein LI
Sri Lanka LK
Liberia LR
Lesotho LS
Lithuania LT
Luxembourg LU
Latvia LV
Libya LY
Morocco MA
Monaco MC
Moldova MD
Montenegro ME
Saint Martin MF
Madagascar MG
Marshall Islands MH
North Macedonia MK
Mali ML
Myanmar MM
Mongolia MN
Macao MO
Northern Mariana Islands MP
Martinique MQ
Mauritania MR
Montserrat MS
Malta MT
Mauritius MU
Maldives MV
Malawi MW
Mexico MX
Malaysia MY
Mozambique MZ
Namibia NA
New Caledonia NC
Niger NE
Norfolk Island NF
Nigeria NG
Nicaragua NI
Netherlands NL
Norway NO
Nepal NP
Nauru NR
Niue NU
New Zealand NZ
Oman OM
Panama PA
Peru PE
French Polynesia PF
Papua New Guinea PG
Philippines PH
Pakistan PK
Poland PL
Saint Pierre and Miquelon PM
Pitcairn PN
Puerto Rico PR
Palestine PS
Portugal PT
Palau PW
Paraguay PY
Qatar QA
Réunion RE
Romania RO
Serbia RS
Russia RU
Rwanda RW
Saudi Arabia SA
Solomon Islands SB
Seychelles SC
Sudan SD
Sweden SE
Singapore SG
Saint Helen SH
Slovenia SI
Svalbard and Jan Mayen SJ
Slovakia SK
Sierra Leone SL
San Marino SM
Senegal SN
Somalia SO
Suriname SR
South SS
Sao Tome and Principe ST
Sint Maarten SX
Syria SY
Eswatini SZ
Turks and Caicos Islands TC
Chad TD
French Southern Territories TF
Togo TG
Thailand TH
Tajikistan TJ
Tokelau TK
Timor-Leste TL
Turkmenistan TM
Tunisia TN
Tonga TO
Turkey TR
Trinidad and Tobago TT
Tuvalu TV
Taiwan TW
Tanzania TZ
Ukraine UA
Uganda UG
United States Minor Outlying Islands UM
United States of America US
Uruguay UY
Uzbekistan UZ
Holy See VA
Saint Vincent and the Grenadines VC
Venezuela VE
Virgin Islands (British) VG
Virgin Islands (U.S.) VI
Vietnam VN
Vanuatu VU
Wallis and Futuna WF
Samoa WS
Yemen YE
Mayotte YT
South Africa ZA
Zambia ZM
Zimbabwe ZW

“browser-info”: {
“language”: “en-US”,
“platform”: “Win32”,
“userAgent”: “Mozilla/5.0 (Windows NT 10.0; Win64; x64; rv:75.0) Gecko/20100101 Firefox/75.0”,
“vendor”: “”
“system-info”: {
“”: “Java™ SE Runtime Environment”,
“java.runtime.version”: “1.8.0_201-b09”,
“java.vendor”: “Oracle Corporation”,
“java.vendor.url”: “”,
“java.version”: “1.8.0_201”,
“”: “Java HotSpot™ 64-Bit Server VM”,
“java.vm.version”: “25.201-b09”,
“”: “Windows 10”,
“os.version”: “10.0”,
“user.language”: “en”,
“user.timezone”: “Asia/Calcutta”
“metabase-info”: {
“databases”: [
“hosting-env”: “unknown”,
“application-database”: “h2”,
“run-mode”: “prod”,
“version”: {
“tag”: “v0.34.0”,
“date”: “2019-12-19”,
“branch”: “release-0.34.x”,
“hash”: “1335215”
“settings”: {
“report-timezone”: null

Try clicking the raw-data-toggle in the bottom-center of the screen (just below the map). That will show what data you have and how it looks.

Latest release is 0.35.3. Try upgrading to that. Make sure to backup before upgrade.

And then you need to migrate away from H2, if you’re using Metabase in production.

It shows this table. Number are correct there. I will upgrade. Once it goes through I will migrate from H to postgres.

Upgraded and checked. It still doesn’t show.

@jiwnaiakbar Try downloading as CSV (one of the bottom-right icons) and verify that the country code does not contain spaces before/after - that’s my only guess why it’s not working.

1 Like

It worked :). There were no spaces in the value but the column in the table was defined as 3 char. I changed the definition to 2 and it worked. Thank You

1 Like