1 Reply Latest reply on Jan 24, 2013 3:55 PM by Shawn Wallwork

    move data mark on map to a more logical location

    Kim Hirst

      I have a map showing Data by a postal code location in North Vancouver and the placement of some of the marks don't make sense.

       

      ie - V7L is in the middle of Georgia Strait. 

       

      See the attachment.  Is there a way to move them to a more logical location?

       

      thanks, Kim at North Van Recreation Commission

        • 1. Re: move data mark on map to a more logical location
          Shawn Wallwork

          Kim, that might be because the zip spans both sides, I don't know. But with a little work you can fix it:

           

          1. Build a Viz with all possible marks visible
          2. Rt-Click the map somewhere away from any marks
          3. View data
          4. Click the upper left corner of the table to highlight the whole sheet (just like in Excel)
          5. Click copy
          6. Past this into an Excel file
          7. Delete the (generated) from both the Lats/Longs
          8. Connect to this worksheet with a live connection
          9. Build your viz again using the Lats/Longs that are NOT (generated).
          10. Now go to your Excel spreadsheet and start experimenting with the Lat for that particular mark (Don't forget to save the Excel file before hitting F5 in Tableau.)

           

          It's hard to tell what you're zoom level is but I start with subtracting (or adding if you want it to go up) .05 or maybe .1

           

          Hope this helps. BTW, if Tableau let you use the generated lat/long fields in a calculation, you wouldn't have to do any of this. Instead you could write a simple statement like this:

           

          IF [Zip]="V7L" THEN [Latitude (generated)] + .05 ELSE  [Latitude (generated)] END

           

          But alas this is not possible.

           

          --Shawn