Skip to main content

My skill with tableau is terrible.  I have a data set I made in alteryx that shows three pieces of information in a Lat/long.

 

Home address

Office Assigned

Optimal Office

 

I am trying to plot the home addresses of these records in the same color as their assigned office.  I want the office to be a star and the homes to be circles.  In some situations the assigned office is not the optimal office.  IN other words there is an office that is closer to their home but for some reason they are not assigned to it.  I want to flag these some how.

 

What do I need to do?  I cant figure out how to get the maps to lay on top of each other.

2 answers
  1. Sep 13, 2019, 1:35 PM

    Hi, John

     

    The idea is to pivot your lat/long data as shown below

    Hi, John The idea is to pivot your lat/long data as shown below and then create lat/long as below and build the view based on thisNot sure how flexiable you can do the data reshape, but just some idea

     

    and then create lat/long as below and build the view based on this

    pastedImage_1.png

    Not sure how flexiable you can do the data reshape, but just some idea for your reference.

     

    Hope this helps

     

    ZZ

0/9000