Our World Statistics Day conversations have been a great reminder of how much statistics can inform our lives. Do you have an example of how statistics has made a difference in your life? Share your story with the Community!
Choose Language Hide Translation Bar

Geographic Maps with Bars

Add the ability to have Bar indicators for locations on a geographic map.  Powerful view, especially with animation showing changes over time or periods.  Attached an example of the view.  Currently cannot get there fullly with current Graph Builder or Bubble Plot Maps.


Tracking Number:

Defect ID: S1428569


I was able to cook something very close using a mix of new features. Here are the steps:

0) Open a dataset with per state data, such as "US Demographics.jmp" from the JMP Sample Library. Note that it also has latitude and longitude for the centroids of each state.

1) Create the desired, per state bar chart in Graph Builder;

2) Move "State" from the role "X" to the role "Page";

3) Use the GB "Make Into Data Table" command to turn the graph into a data table. You should have 50 rows and two columns named "State" and "Graph"

4) RMB on the State column header, tag it as a "Link ID" (we are going to use it for a virtual join)

5) Save this table to the file system;

6) On the original dataset, RMB on the State column header, tag it as a Link Reference to the previous table.

7) RMB on the new, linked "Graph" column and tag its "User for Marker" property.

7) Create a new GB, drop "State" in "Map Shape" role

8) Add a "Points" Plot as an overlay (drag the icon from the toolbar over the map)

You can use one of the variables for the color background, a nice way to provide context for the graphs.

If you want a clean look as the one in the original image:

9) Assign a measure to the color role; 

10) RMB on the legend, set transparency to 0.


The end result should look like this. 

I hope you will find this helpful!


Map with graph markersMap with graph markers

JMP CookBook entry with full script now available here.