Map report help, country name

[Luiz Lucena]

Hi guys, 

Trying to create a map report based on Office Location (Country, State, City) for our custom field Affected User (u_affected_user).

As an example, see the map below, showing the US with only 169 incidents.
An a warning informing that the mapping needs to be corrected.

The mapping is using the field Office Location, which in turns is associated to users through the cmn_location table.

Already found that the cause for this is the Country Name. 
For the US, if I change the location country name below to USA from United States, all records for Miami appears in the report above.

We use the country name (like United States) in many other catalog items, UI policies, workflows scripts, etc. So rename the locations back to USA is out of scope.

Does anyone know how to remap this to United States instead of USA?
 

[Adam Stout · Accepted solution]

Go into Map Sources then go into the map and create a new set of "Country Mappings" or just update the one you have to the Key value to match the expected string.

I covered this in one of the last sections in this lab:  https://nowlearning.service-now.com/lxp?id=overview&sys_id=fb985e031bac98501759b8c11a4bcba0&type=cou...

[Luiz Lucena]

Thanks, Adam!

Was writing my response below at same time you replied answering the question below.
Perfect timing!

By the way, awesome job with the COVID-19 reporting, I'm going to that training now!

Thank you and stay safe! 

[Luiz Lucena]

Found a possible solution in the documentation:

https://docs.servicenow.com/bundle/orlando-performance-analytics-and-reporting/page/use/reporting/ta...

I'm willing to rename the existing mapping to United States instead of creating a new one, because the system only allow one mapping per ISO code (us).

[Bhanu Kiran]

We have an existing article that might help you, in case you are not aware. You can find it here! KB0799718