World Map report

[Robert Hames]

I need to create a World Map report showing the number of Projects we have in each country. I have a custom table called Customers that has the Country as a column.

The documentation for a World Map is talking about mapping to a .location column. 

How do I map my Country column to a .location column so that I can create a World Map report?

[Community Alums]

Hi @Robert Hames ,

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.

here are few source mapping examples:

Mark my answer correct & Helpful, if Applicable.

Thanks,

Sandeep

[Robert Hames]

@Sandeep Dutta

I appreciate your reply, and I got pulled off onto other projects, and am now just getting back to creating the World Map.

I created a Map Source that points to the Country column in our Customer table that is referenced by our Project table. (see screenshot below)

Then, I created a child Map Source and told it to "Use mapping", and "Country mappings" thinking that it would take the Country out of my Customer table, and map that to the World Map. (see second and third screenshot)

Finally, I created the World Map report, and told it to use "Project by Country" for its data mapping. It created a map, but it only has 2 projects in one country. It appears to be going by my Customer Name instead of the Country as the Customer Name for those 2 projects happen to be the name of the Country. All my other projects have a Customer name that is internally generated, and wouldn't map back to a country.

You are the only one that replied to this, so I thought I would circle back to you. I really appreciated your reply the first time, and would appreciate any insights you could give me on this.