Map Report not working as expected with Country Mappings > Use Latitude and longitude
- Mark as New
- Bookmark
- Subscribe
- Mute
- Subscribe to RSS Feed
- Permalink
- Report Inappropriate Content
04-11-2019 08:30 AM
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?
- Labels:
-
Reporting
- Mark as New
- Bookmark
- Subscribe
- Mute
- Subscribe to RSS Feed
- Permalink
- Report Inappropriate Content
04-17-2019 11:00 PM
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.