Geomap not working as expected | Troubleshooting guideIssue <!-- /*NS Branding Styles*/ --> .ns-kb-css-body-editor-container { p { font-size: 12pt; font-family: Lato; color: var(--now-color--text-primary, #000000); } span { font-size: 12pt; font-family: Lato; color: var(--now-color--text-primary, #000000); } h2 { font-size: 24pt; font-family: Lato; color: var(--now-color--text-primary, black); } h3 { font-size: 18pt; font-family: Lato; color: var(--now-color--text-primary, black); } h4 { font-size: 14pt; font-family: Lato; color: var(--now-color--text-primary, black); } a { font-size: 12pt; font-family: Lato; color: var(--now-color--link-primary, #00718F); } a:hover { font-size: 12pt; color: var(--now-color--link-primary, #024F69); } a:target { font-size: 12pt; color: var(--now-color--link-primary, #032D42); } a:visited { font-size: 12pt; color: var(--now-color--link-primary, #00718f); } ul { font-size: 12pt; font-family: Lato; } li { font-size: 12pt; font-family: Lato; } img { display: ; max-width: ; width: ; height: ; } } This article is ment to help cover and clarify what is wrong in the following cases, Geomap is not working properly or as expectedMap is not showing up or taking forever to loadDrilling down on the geomap is breaking when going to a new map levelGeomap doesn't highlight country or state on the map as expectedGeomap is showing dots and/or they are in the wrong locationsGeomap showing an error that data can't be displayed on the map Facts<!-- /*NS Branding Styles*/ --> .ns-kb-css-body-editor-container { p { font-size: 12pt; font-family: Lato; color: var(--now-color--text-primary, #000000); } span { font-size: 12pt; font-family: Lato; color: var(--now-color--text-primary, #000000); } h2 { font-size: 24pt; font-family: Lato; color: var(--now-color--text-primary, black); } h3 { font-size: 18pt; font-family: Lato; color: var(--now-color--text-primary, black); } h4 { font-size: 14pt; font-family: Lato; color: var(--now-color--text-primary, black); } a { font-size: 12pt; font-family: Lato; color: var(--now-color--link-primary, #00718F); } a:hover { font-size: 12pt; color: var(--now-color--link-primary, #024F69); } a:target { font-size: 12pt; color: var(--now-color--link-primary, #032D42); } a:visited { font-size: 12pt; color: var(--now-color--link-primary, #00718f); } ul { font-size: 12pt; font-family: Lato; } li { font-size: 12pt; font-family: Lato; } img { display: ; max-width: ; width: ; height: ; } } Overview of the Key Mapping Tables: sys_report_map - the actual map, the JSON that plots out the map, holds the hc-keys, etc.sys_report_map_type - sets up the levels of maps, 1 = World, 2 = Country, etcsys_report_map_source - A set of cascading association that defines how to group and drill down into a mapsys_report_map_condition - conditional filtering of values to show on a mapsys_report_map_source_mappings - mapping values from the map_source to the hc-key value in the map JSONsys_report_map_source_mapping - Grouping of the different mapping levelsviz_map_source - Same as sys_report_map_source for the new Data Visualization / Platform Analytics product. Explanation of the Lat/Long mapping error, The lat/long mapping error is reporting for ALL data on that level, even though you are only viewing a specific state / country it will still alert to any data errors for other states/countries. The map level filters what you see, not the data that is considered for display. Release<!-- /*NS Branding Styles*/ --> .ns-kb-css-body-editor-container { p { font-size: 12pt; font-family: Lato; color: var(--now-color--text-primary, #000000); } span { font-size: 12pt; font-family: Lato; color: var(--now-color--text-primary, #000000); } h2 { font-size: 24pt; font-family: Lato; color: var(--now-color--text-primary, black); } h3 { font-size: 18pt; font-family: Lato; color: var(--now-color--text-primary, black); } h4 { font-size: 14pt; font-family: Lato; color: var(--now-color--text-primary, black); } a { font-size: 12pt; font-family: Lato; color: var(--now-color--link-primary, #00718F); } a:hover { font-size: 12pt; color: var(--now-color--link-primary, #024F69); } a:target { font-size: 12pt; color: var(--now-color--link-primary, #032D42); } a:visited { font-size: 12pt; color: var(--now-color--link-primary, #00718f); } ul { font-size: 12pt; font-family: Lato; } li { font-size: 12pt; font-family: Lato; } img { display: ; max-width: ; width: ; height: ; } } Any Resolution<!-- /*NS Branding Styles*/ --> .ns-kb-css-body-editor-container { p { font-size: 12pt; font-family: Lato; color: var(--now-color--text-primary, #000000); } span { font-size: 12pt; font-family: Lato; color: var(--now-color--text-primary, #000000); } h2 { font-size: 24pt; font-family: Lato; color: var(--now-color--text-primary, black); } h3 { font-size: 18pt; font-family: Lato; color: var(--now-color--text-primary, black); } h4 { font-size: 14pt; font-family: Lato; color: var(--now-color--text-primary, black); } a { font-size: 12pt; font-family: Lato; color: var(--now-color--link-primary, #00718F); } a:hover { font-size: 12pt; color: var(--now-color--link-primary, #024F69); } a:target { font-size: 12pt; color: var(--now-color--link-primary, #032D42); } a:visited { font-size: 12pt; color: var(--now-color--link-primary, #00718f); } ul { font-size: 12pt; font-family: Lato; } li { font-size: 12pt; font-family: Lato; } img { display: ; max-width: ; width: ; height: ; } } 1. Check sys_report_map_source table (Old Reporting) or the viz_map_source table (Platform Analytics). These tables tell the geomap how to initially display you data, how to group it, and how to drill down or up in the maps. Lets look at an OOTB example for the sys_user table. NameTableFieldLevelParentUse These MappingsHow to use dataUser by locationuser [sys_user]location(empty)(empty)(empty) User by location (level 1)user [sys_user]location.countryLevel 1User by locationCountry mappingsUse mappingUser by location (level 2)user [sys_user]location.stateLevel 2User by location (level 1)Region and State mappingsUse mappingUser by location (level 3)user [sys_user]location.cityLevel 3User by location (level 2)(empty)Use Latitude and Longitude Name is the general association and will show up in the "Group By" or "Report On" option of your map's configuration.Table is a value declaring the base table you want to map on or a common table reference.Field value details what data the map should be looking at on each level. This Field can dot walk!Level relates the row to the Map Levels ( 1 = world, 2 = Country, 3 = State )Parent values describe how the map should drill down in the map.Use These Mappings and How to use data specify if other lookups are necessary to display your data. (Sections 2 below) Other notes about the records as a set, The first record is a general association, this is normally a reference to 'location' which is commonly the cmn_location table. The rest of the record's NEED to map to String values and NOT a Reference value. A Reference returns a sys_id and breaks the map. If one of your Fields is a Reference you need to update the record to dot walk to a field with a String value.Example, location.country might need to be changed to location.country.name The new viz_map_source table only has one record set for "Location" so any table can be mapped if it has reference "Location" (cmn_location). "Group by" in the map configuration can be used to specify the Location reference.Example, Group by = Incident.Caller.location OR Incident.Assigned To.location 2. Check the sys_report_map_source_mappings table, the Key value(s) needs to equal the value(s) from the Field column specified in section 1. KeyValueMapMap Source MappingFLus-flUnited States of AmericaRegion and state mappings If location.country = "Canada" then there needs to be a Key for "Canada", the value can be anything as long as the equivalent key exists.You can create these aliases but data standardization is recommended over multiple Keys for each variation (CA, CANADA, Canada)The Value column connects to the hc-key value found in the JSON of the Map column reference (sys_report_map). 3. Check the table you are mapping on and confirm you have data in all your records for the columns specified in Section 1. This step usually has the most work to do so there are a few ways to do this, Scripts to update recordsMass update from the List ( Click + Drag to update multiple records at once) You will probably need to standardized values in the Fields specified from Section 1. State = ('Florida', 'florida', 'fl', 'FL', etc) --- should be standardized to ---> 'Florida'