You'll have better results overall if you were to include a new column of data in your original set, for State/Province and fill that column with the appropriate values. That will help resolve the geographic hierarchy gap.
You should have, City-->State/Province-->Country.
Your data doesn't include State/Province, so jumping from one level of detail to a different level of detail, skipping a middle level of detail needed to support the location. Hope that helps answer your question and why Tableau is behaving the way that it is for correction of locations using the Edit feature.
If yes, please mark this response as correct so that others may find it useful in the future. Thx, Don
Thanks Don. I tried to add the state/province detail but it does not work either. Apparently there is some kind of issue with the geolocalization of some US cities.
Does anyone experienced the same?
I would have expected that Don's suggestion to add State/Province detail to the data, making sure the Geographic Role is set to "State/Province" for the field, and then adding the State field to the Marks card would have fixed this issue.
Did it fix any of the unknown cities when you added State/Province detail? Or did you still end up with same number of unknown locations?