Join the #BuildWithBuildAgent Challenge! Get recognized, earn exclusive swag, and inspire the ServiceNow Community with what you can build using Build Agent.  Join the Challenge.

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.