Hi,
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.
@jiwnaiakbar
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 |
El |
SV |
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.runtime.name”: “Java™ SE Runtime Environment”,
“java.runtime.version”: “1.8.0_201-b09”,
“java.vendor”: “Oracle Corporation”,
“java.vendor.url”: “http://java.oracle.com/”,
“java.version”: “1.8.0_201”,
“java.vm.name”: “Java HotSpot™ 64-Bit Server VM”,
“java.vm.version”: “25.201-b09”,
“os.name”: “Windows 10”,
“os.version”: “10.0”,
“user.language”: “en”,
“user.timezone”: “Asia/Calcutta”
},
“metabase-info”: {
“databases”: [
“h2”,
“sqlserver”,
“postgres”
],
“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
}
}
}
@jiwnaiakbar
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.
https://www.metabase.com/docs/latest/operations-guide/migrating-from-h2.html
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