451384_en-US

liliconcom

Map Shapes Not Found In Graph Builder ( Great Britain)

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

GraphicsOtherRe: Map Shapes Not Found In Graph Builder ( Great Britain)

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
 );
);

Re: Map Shapes Not Found In Graph Builder ( Great Britain)

You can edit the built-in map shape files to add the alternative names for these geographies.

 

The map files are in C:\Program Files\SAS\JMP[or JMPPRO]\[VERSION NUMBER]\Maps. So for JMP Pro 16 they are in C:\Program Files\SAS\JMPPRO\16\Maps.

Open the World-Name.jmp file and find the United Kingdom row and add the alternative names, separating them with a | symbol.