Hi -
I have question regarding the use of United States Counties on the Map Visualization.
In my data table / data load I have the following fields:
[LocationTable]:
LOAD
[SalesLocationID],
[City],
[State],
[Zip],
[City-State],
[Country Code],
[Latitude],
[Longitude],
[Region],
[Divison],
[County],
APPLYMAP( '__countryCodeIsoThree2Polygon', APPLYMAP( '__countryName2IsoThree', LOWER([Country Code])), '-') AS [LocationTable.Country Code_GeoInfo],
GeoMakePoint([Latitude], [Longitude]) AS [Longitude_Latitude]
FROM [lib://DataFiles/ABC123.xlsx]
(ooxml, embedded labels, table is LocationTable);
I have created a point layer using the longitude and latitude for the city - works perfect!
When I create an area layer for the County - some counties are not displaying in the correct state (just a few) as the county is related to the state and zip in the specific data row.
Any thoughts on how to make this would correctly ?
Thanks - Jerry
