3 Replies Latest reply on Jun 10, 2017 9:13 PM by Sandipan Chakraborty

    Can you do Custom Geocoding for Multiple Countries?

    Tom Jennings

      This is one example, but we have a value called Rest of Latin America in the Country column in our reporting.

       

      The countries included in Rest of Latin America are:

       

      Argentina

      Chile

      Colombia

      Costa Rica

      Ecuador

      El Salvador

      Guatemala

      Honduras

      Peru

      Venezuela

      Puerto Rico

      Trinidad and Tobago

      Dominican Republic

      Jamaica

      Panama

       

      The volumes of these countries are generally really smaller so they are combined until the business grows.

       

      When I Edit Locations when I do a Map Chart I only get to assign one country to my column values.  For Example, Argentina would be the only country I can assign.

       

      Can you assign multiple countries using custom geocoding so that I could have the same Rest of Latin America score show for each country?

        • 1. Re: Can you do Custom Geocoding for Multiple Countries?
          Dana Withers

          I'm not sure if this is a valid option with your setup, but would it not be more handy to keep the country name as the actual country name in your country column and then do your reporting based on a country grouping where you mark those countries as "rest of..."?

          That would keep your data more correct, allow your maps to work and still keep all your figures grouped.

          Also it would mean that if business picks up big time in just one of the countries, it can come out of the group and be reported on on it's own.

          • 2. Re: Can you do Custom Geocoding for Multiple Countries?
            Allan Walker

            Hi Tom,

             

            I think given what you want to achieve, I'd be tempted to make a merged shape file up, and use the polygon mark type.

             

            What administration level do you need?  If level 1, Tableau Mapping has access to Natural Earth Admin 1 data set (free of copyright and restrictions) in Tableau ready format. All you would need to do is group up the countries listed above. If just the outlines, i.e. Admin 0, then that's a lot easier.

             

            Natural Earth Admin Level One, with the countries filtered as above.

            Map.png

             

            Best Regards,

             

            Allan

            • 3. Re: Can you do Custom Geocoding for Multiple Countries?
              Sandipan Chakraborty

              I have the same problem. In my case, I need to represent TRIFECTA which consists of multiple countries showing profit over the last 6 months. I also have to represent CN-HK which comes to China and Hongkong. I have to represent both of them. Please help.