I started using Metabase and it is a fantastic product. Love the ease of use and the ability to use direct SQL. I am creating a map and while I get the visualization right, I am not seeing the metric field being populated. Am I missing something?
Orders and countrycode.
+--------+-------------+----------------+-------------+ | orders | region | nation | countrycode | +--------+-------------+----------------+-------------+ | 249705 | EUROPE | FRANCE | FR | | 249551 | MIDDLE EAST | IRAQ | IQ | | 249056 | ASIA | INDONESIA | ID | | 248990 | AFRICA | ETHIOPIA | ET | | 248693 | EUROPE | UNITED KINGDOM | GB | | 248048 | AMERICA | UNITED STATES | US | | 247640 | AMERICA | BRAZIL | BR | | 247628 | EUROPE | ROMANIA | RO | | 247599 | AMERICA | ARGENTINA | AR | | 247570 | ASIA | CHINA | CN | | 247563 | MIDDLE EAST | JORDAN | JO | | 247462 | MIDDLE EAST | EGYPT | EG | | 247429 | EUROPE | GERMANY | DE | | 247409 | EUROPE | RUSSIA | RU | | 247346 | ASIA | INDIA | IN | | 247201 | AFRICA | MOZAMBIQUE | MZ | | 246746 | AFRICA | ALGERIA | DZ | | 246564 | ASIA | VIETNAM | VN | | 246360 | ASIA | JAPAN | JP | | 246210 | AFRICA | KENYA | KE | | 245812 | MIDDLE EAST | IRAN | IR | | 245799 | AFRICA | MOROCCO | MA | | 245362 | AMERICA | CANADA | CA | | 245131 | MIDDLE EAST | SAUDI ARABIA | SA | | 245124 | AMERICA | PERU | PE | +--------+-------------+----------------+-------------+ 25 rows in set (0.56 sec)
These are the results I am trying to map.
When I do a mouse-over the map, I see that the orders and countrycode have been flipped. For example - the mouse-over shows orders as USA and countrycode as 248048
I switched to pin maps and it worked. Not sure what is the problem with the other map. I was running on Mac and also had frequent restarts. Looks to be much more stable on Linux running as jar.