2 Replies Latest reply on Jun 13, 2018 1:41 AM by Mavis Liu

    Customer list maps

    Alex Martino

      Hello. If I have a list of customers with names/zip codes, is there a way that I can create like a heat map to see where most of our customers are? Or some type of map?

       

      Also, is there a software that identifies names as male or female? Thanks!!

        • 1. Re: Customer list maps
          Peter Fakan

          Hi Alex,

           

          You can set zip code to geography inside tableau so this is mappable, can't help you on your software issue though.

           

           

           

          HTH

           

          Peter

          • 2. Re: Customer list maps
            Mavis Liu

            Hi Alex,

             

            Yes as Peter says, please update your zip code to a geographical role of zip code:

             

            2018-06-13_09h37_04.png

             

            Please note that Tableau will map out the AREA part of the zip code. Not to the street level.

             

            Next, on a blank worksheet, bring your zip code field into the centre of the canvas, where you'll find the rows and columns will be auto populated with latitude and longitude. Then bring your name field into colour on the marks card, right click on this and change it to a measure by using count or count distinct.

             

            2018-06-13_09h37_40.png

             

            You should then get this kind of view:

             

            2018-06-13_09h40_06.png

             

            Have attached the workbook for you to see how it works.

             

            Thanks,

             

            Mavis