Map Shapes Not Found In Graph Builder ( Great Britain)

d_barnett

I use Graph Builder quite a bit to demonstrate where my JMP users are based in the world. We can automatically pick up where they are based via a Smartsheet ( https://www.smartsheet.com/) but one of the annoyances is that Smartsheet calls the UK Great Britain which JMP doesn't recognize. This means that i have to change these manually each time to run the report, I realize I could have a script to do this but it would be great to have it automatically done for me in graph builder.

 

It is the same for Korea ( South) and Taiwan, R.O.C.

 

Is there a way to change the map service that JMP uses so that these are recognised? I don't have the potential to change the Smartsheet documentation as it is linked to a larger db. 

 

David

Mark_Bailey

I would check the Wish List here and see if this change has been requested. If so, vote for it! (Kudo or comment or both) If not, then add your request.

 

Given that it might be a long time before it is adopted, you might use the Recode command the Cols menu to make the changes. You could also adapt this script and run it when you get a new data table from SmartSheet.

 

Names Default to Here( 1 );

For Each Row(
	:Country = Match( :Country,
		"Great Britain", "UK",
		"Korea (South)", "South Korea",
		// and so on to the last change,
		:Country
	);
);