Forum Discussion

dibbkd's avatar
dibbkd
Frequent Visitor
9 years ago

Labels on Maps

I have a few thousand addresses for all my clients, and also a couple addresses for our clinic locations.

 

I want to have a map that shows my clients in blue and my clinic locations in red.

 

I have a table of addresses for clients and a separate smaller table for my clinic location addresses.

 

I do already know how to make a single map, but not sure how to make some locatoins be different colors than others.

7 Replies

  • Hi there, what you can do is if you have both of your clients addresses and clinic locations in one table, you could add a conditional column which would be for example called "Classification" and if it is a customer then it would be classified as "Customer" and if it was a clinic then classified as a "Clinic"

     

    Then when you create your map you could then and put the Classification under the "Legend"

     

    As with the attached picture, you will see that I have my Amount under Size, and then under Legend I have got my Fiscal Date, which shows in all the different colours.

    • dibbkd's avatar
      dibbkd
      Frequent Visitor

      Hey thank you, that does work.

       

      But still wondering how to do it with two tables, because my client addresses has a bunch of other information that my clinic locations doesn't have, and also just wondering how to do it with two tables to learn another way.

       

      Appreciate your knowledge!

      • GilbertQ's avatar
        GilbertQ
        Super User

        Hi there

         

        If I understand correctly, can you not create 2 maps with different requirements?

         

        So that each map is representative of what you are trying to achieve?

  • Anonymous's avatar
    Anonymous
    Not applicable

    Hi dibbkd,

     

    Has guavaq's solution solve your issue?

     

    Regards,

    Xiaoxin Sheng

    • dibbkd's avatar
      dibbkd
      Frequent Visitor

      I want one map that shows my clients (a few thousand of them), and also shows my several clinic loations in another color.   I have a mySQL database I'm pulling the client info from, and a separate small table with my clinic locations.  I don't want to have to edit the client table to add my clinic locations each time, and also they contain different information besides the address.