The map shown below is the floor, grouped by time of day. The color reflects the Fahrenheit value. Exploring data visually in this way can give hints as to what factors are affecting office temperature. Looking at this map, it appears the offices on the east side of the building are warmer in the mornings than they are in the afternoons. On the western side of the building, the opposite appears to be true. From this visualization, we might expect that both of these variables are affecting office temperatures, or perhaps that the interaction between these terms is significant. Such visuals help guide decision-making during the analysis.
Room/Office Colored by Fahrenheit and Grouped by Time of Day
First, data was collected and input into a data table (S4 Temps.jmp). Note the Room/Office column. It contains the unique names for each office and was assigned the Map Role to correctly define the map files.
S4 Temps.jmp Data Table
Then, a map of the floor was created using the Custom Map Creator add-in, which you can download from the JMP File Exchange at https://community.jmp.com/docs/DOC-6218. The add-in creates two tables to define the shapes; an XY table and a Name table. The instructions below describe how it was built.
1.
Launch the add-in through the menu items Add-Ins > Map Shapes > Custom Map Creator. Two tables open in the background followed by the Custom Map Creator Window.
5.
Click Next.
8.
As soon as you finish defining the boundaries of the shape, click Next Shape. Continue adding shapes until you have completed the floor plan. Note that you do not need to connect the final boundary point; the add-in automatically does that for you when you click Next Shape.
9.
The line size and color can be changed. In addition, checking Fill Shapes fills each shape with a random color.
10.
Click Finish.
The custom map files were created and named appropriately. The map files are S4-Name.jmp and S4-XY.jmp and have been saved in the JMP Samples/Data folder.
Note: Pathnames in this section refer to the “JMP” folder. On Windows, in JMP Pro, the “JMP” folder is named “JMPPro”. In JMP Shrinkwrap, the “JMP” folder is named “JMPSW”.
The S4 Temps.jmp data table contains office data over a three-day period. Set up the Map Role column property in the data table, as follows:
1.
Select Help > Sample Data Library and open S4 Temps.jmp.
2.
Right-click the Room/Office column and select Column Info.
3.
Select Column Properties > Map Role.
4.
Select Shape Name Use.
5.
Click the icon next to Map name data table and browse to the S4-Name.jmp file (located in the JMP Samples/Data folder).
6.
Select room from the Shape definition column list.
Room is the specific column within the S4-Name.jmp data table that contains the unique names for each office. Notice that the room column has the Shape Name Definition Map Role property assigned, as part of correctly defining the map files.
Note: Remember, the Shape ID column in the -Name data table maps to the Shape ID column in the -XY data table. This means that indicating where the -Name data table resides links it to the -XY data table, so that JMP has everything that it needs to create the map.
Map Role Column Property
7.
Once the Map Role column property has been set up, you can perform your analysis. You want to visually see the differences in office temperatures throughout the floor.
1.
Select Graph > Graph Builder.
2.
Drag and drop room/office into the Map Shape zone.
Since you have defined the Map Role column property on this column, the map appears.
3.
Drag and drop Fahrenheit to the Color zone.
Room/Office Colored by Fahrenheit
4.
Drag and drop Time of Day onto Group X zone.
Room/Office Colored by Fahrenheit and Grouped by Time of Day
To view Room/Office Map with Original Floor Plan, select Help > Sample Data Library and open S4 Temps.jmp and run the by Time of Day script.
Room/Office Map with Original Floor Plan

Help created on 9/19/2017