Map Report not working as expected with Country Mappings > Use Latitude and longitude

j_cafardi
Kilo Explorer

I created a Map Source on the incident caller location field.  The map source has the first level using Country mappings and then the second level uses latitude and longitude.  When I generate a map report, the country level appears to be working, but when I select the count for USA it will only show one item on the USA mapping, it shows Raleigh.  I am seeing this in a fresh developer instance(London).  I created a report on the incident table and filtered to only show incidents where the caller.location field is not empty. 

The reason I am setting up the second level as latitude and longitude, is because my company is concerned we wont be able to maintain consistency on the State /Province field. 

Has anyone experienced this issue?  Any advice on how to proceed?

 

5 REPLIES 5

You may need to work directly with the table sys_report_map to fulfill this requirement. This is what defines the hierarchy of the mapping levels.