I think you only changed the name for the geolocation, so it works ok for map.
I would join your data with a Table containing all states and country name. So, if your [Destination] is Florida you will get a new field wi US in it. If the [Destitation] is on country level there will be no match and you will end up with null. Than you can write a calculation saying, if the jointed country field is null than take the original destination.
Hope you can get what I mean,
I understand what you mean. However, country and state is currently in one variable. Even if I duplicate it and set one to country, one to city, the calculated field cannot be used because it is not "null'.
Only under "edit mapping" then it will be shown as unrecognized.