What's the JMP-fluent way to do this?

Question

Manufacturing process. In R&D, we conceptualize the product as a grid of squares.

+---+---+---+---+---+---+---+---+
5 |   |   |   |   |   |   |   |   |
  +---+---+---+---+---+---+---+---+
4 |   |   |   |   |   |   |   |   |
  +---+---+---+---+---+---+---+---+
3 |   |   |   |   |   |   |   |   |
  +---+---+---+---+---+---+---+---+
2 |   |   |   |   |   |   |   |   |
  +---+---+---+---+---+---+---+---+
1 |   |   |   |   |   |   |   |   |
  +---+---+---+---+---+---+---+---+
    1   2   3   4   5   6   7   8

Artwork by ChatGPT.

So the locations are named by their XY, from 0101 to 0508.

Data looks like:

ID    | Grade |  A  |  B  |  C
------+-------+-----+-----+-----
0101  |   0   |  1  |  8  |  0
0102  |   1   |  .  |  9  |  0
0103  |   1   |  .  |  7  |  100

Right now, I'm constructing the grid inside a Graph Box loop, and I'm asking the user to toggle between "views". As the user toggles view, the grid coloring changes, but I'm writing that part by hand, with a bunch of ifs, fill color("dark blue"), etc.

Rather than hard-coding color-value associations on a per column basis, is there some JMP feature I can use to throw that to the user? Let them choose a column and color scheme, but have it displayed on the grid?

John_Powell_JMP · Answer

Hi @mtowle419 ,

If you are willing to split the Location ID into X and Y columns, you could use Graph Builder and drag these columns into the X and Y roles.

Then select the Heatmap element and drag column A into the Color role.

You can pick an appropriate color gradient.

To allow the user to toggle to display colors for column A, B, and C, you would add a Column Switcher and include these three columns.

Here's how it would look using the Big Class sample data set if we pretend X=sex and Y=age and having height in the Color role that can be toggled with weight, where you would use column A, B, and C.

Here's the JSL script if you would like to try it yourself:

Graph Builder(
	Size( 151, 233 ),
	Show Control Panel( 0 ),
	Variables( X( :sex ), Y( :age ), Color( :height ) ),
	Elements( Heatmap( X, Y, Legend( 5 ) ) ),
	Column Switcher( :height, {:height, :weight} )
);

~John

hogi · Answer

Please have a look at Shape file, e.g. How do I Create a Semiconductor Wafer Heat Map?
They can be used in Graph Builder to display pre-defined grids.

Once you have created your custom Shape file and set up the link to the Shape file, all you need to do is drag your ID column onto the Shape drop zone: