I have a list of all US counties/states and converted the data type to geographic. My columns are State | County | Employee. When the map chart is generated it only colors in the state using the first record for each. Is it possible to have it color the county regions individual with the assigned employee?

Screen Shot 2021-04-13 at 4.43.06 PM.png