Forum Discussion
Labels on Maps
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.
- dibbkd9 years agoFrequent 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!
- GilbertQ9 years agoSuper 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?
- dibbkd9 years agoFrequent 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.