Visualization Map with different colours

[phitho]

I have a map I am trying to build where I would like 1 set of cities to be blue, and another set to be red, all on the same map. Is this something that can be done?

 

[severynm]

Absolutely it can. Do you know the criteria you want to use to apply the color formatting?

 

[phitho]

1 City refers to the location of employees, and the second City would identify locations of offices.

Should I have all that data in 1 table, or can I use 2 data sources?
If 1 table, would I have 1 city column, with a second column as a Type, which would have Employee and Office as the values? (just trying to think this through on my own)

 

[severynm]

It depends. There's really no good answer for this. I my opinion it is easier to have everything in fewer tables (and it will also be the case if you're only dealing with a few columns instead of dozens - which it sounds like is the case here), but if your data is coming in from two different sources then it may be better to keep them separate and relate them together somehow in the model.

If 1 table, would I have 1 city column, with a second column as a Type, which would have Employee and Office as the values? (just trying to think this through on my own)

Knowing absolutely nothing about your data except this, it sounds like 4 columns are appropriate: City, Type, Employee, Office.