5 Replies Latest reply on Sep 25, 2018 11:59 AM by Lohitha Devireddy

    Mapping cities when state/province data is available outside the US/Canada

    Marc Beebe

      I'm trying to map locations of our student branches and I'm having trouble displaying all the data.  For the locations inside the United States or Canada, the data contains state or province.  However, for data in any other country we don't have state/province data, just city. If I include State/Province, it only shows US and Canada, the two countries with that data.  However, when State/Province is removed, locations all across the world are shown.

       

      I want to use State/Province to pick up the cities in the US and Canada where the same city name exists in multiple states. 

       

      Is there a way to have it include the State/Province and only use it for US and Canada, or perhaps create a new calculated field that automatically changes geographic role depending on country.

       

      Thanks!

       

      Marc

       

      Student Branch test.jpg