I tried visualizing the countries with their respective states in Metabase using the names of the country and their states. I did not get the desired results. Rather, the map visualization gave me countries all over the world map that I did not even ask for. Is it because the data that I am using for the countries' and states' names may not be compatible with Metabase?
Can someone please guide me on this. I hope my doubt is clear.