Labels on Maps

[dibbkd]

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.

[Anonymous]

Hi @dibbkd,

Has guavaq's solution solve your issue?

Regards,

Xiaoxin Sheng

[dibbkd]

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.

[GilbertQ]

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]

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]

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?

[dibbkd]

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.

[GilbertQ]

Hi there what I can suggest is in your client data, to add a Custom Colum called "Classification" and put in there "Client"

Next for your Clinic Locations data add a Custom Colum called "Classification" and put in there "Clinic"

Then Append the data in the Query Editor to your Clients data (so you will append from your Clinic data). In doing so you can have all your data in one table. And then you can use the Classification on the map to show them as different colours.