Forum Discussion
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
- GilbertQSuper User
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.
- dibbkdFrequent 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!
- GilbertQSuper 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?
- AnonymousNot applicable
- dibbkdFrequent 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.