The short answer is Yes.
The Zipcode map is not distributed with the basic JMP or JMPPro product. However, the maps are downloadable from the File Exchange
and then open the 2 data tables and save them to
Then open your file that has you Dollar data in it, along with the Zipcode it is associated with.
Go to Graph Builder, Drag the Zipcode column to the Shape area of the display, and the Dollar column to the center of the display, and you will get a map like the one displayed above.
Sorry, another quick question.. do the zip codes in my file have to be in a specific format? I am currently using the character format so a zip code of "00012" doesn't change to "12".
When I drag the zip codes into the Shape area it does not give me a shape of the US. Am I doing something wrong?
The zip code needs to be character, for just the reason's you suggested.
Concerning your issue:
What version of JMP and what operating system are you running on?
Did you copy the 2 files to the directory specified? You may have to create some directories that are not currently available.
Both the -XY and the -Name data tables need to be copied to the correct folder
Since the zip code files are large, it may take a while for the map to show up.
Attached is a data table that I knows works with the zip code shape files, so if you try it, and it works, then the issue is with your data table. If you try it and it doesn't work, then your issue is with the install of the shape files from the Xan Gregg files I pointed you to.
Thank you txnelson. It worked like a charm on my JMP version 14. However, I have three questions to proceed:
1) as you might be able to see in the enclosed image, I need to add an underlying map with geographical data. How do I do that?
2) the color depth and the information obtained in the popup window when I place the cursor on one of the divisions, is just the numbers of the JMP table rows represented in each zip code area. I need a summary statistics (mean, median) of the actual variable displayed across the rows.
3) is there a more recent zip code file available?. The one you mention seems to be OK, but it is 10 years old and I would need to disclose that fact to users.