Heatmap overlay from multiple variables

OleksandrG

I collect a response from MxN sensor. The data comes as a table with multiple variables stored in individual columns ParamA, ParamB, ParamC.

TLDR: I want to obtain two heatmaps on the right in the sketch below.

 

In the first application, I would like to plot a heatmap resulting from an overlay of two logical variables, i.e. ParamA=1 as Blue, ParamB=1 as Red, ParamA=1&ParamB=1 as Magenta.

 

In the second application, I would like to overlay a heatmap of continuous variable ParamC (as Fill Color) with heatmap of logical variable ParamA (as Fill Pattern).

 

I would prefer to avoid calculating a separate column for these maps since actual data has dozens of variables resulting in too many permutations. Ideally I would like to use a solution from Graph Builder, without scripting.

I use JMP 18.1.1.

JMP heatmap overlay example.png

JMP heatmap overlay, dummy data.jmp

christian-z

My suggestion is to overlay two Heatmaps in the Graph Builder window.  

Select both columns you wish to color by, and drag them to the color role. For example: 

Next, right-click anywhere within the Heatmap graph and select Add > Heatmap. Now you have two duplicate heatmaps, each with both Params in the color role. Under Variables, de-select one Param in each Heatmap's Color assignment, so that each Heatmap is colored according to that Param only. For example:

Finally, change each Param's color or pattern encoding as desired. Note that the heatmap at the bottom of this list will be on top on the graphic. (Note: With no scripting, I think only 2 Params can be overlaid - but if you edit the script, you can add all 3 and generalize this method to overlay more than two Heatmaps.) 

Here's a script for example 1: 

View more...

 

Graph Builder(
	Size( 518, 448 ),
	Show Control Panel( 0 ),
	Variables( X( :col ), Y( :row ), Color( :ParamA ), Color( :ParamB ) ),
	Elements(
		Heatmap( X, Y, Color( 2 ), Legend( 5 ) ),
		Heatmap( X, Y, Color( 1 ), Legend( 6 ) )
	),
	SendToReport(
		Dispatch( {}, "400", ScaleBox,
			{Legend Model(
				5,
				Properties( 0, {Transparency( 0 )}, Item ID( "0", 1 ) ),
				Properties( 1, {Transparency( 0.5 )}, Item ID( "1", 1 ) )
			), Legend Model(
				6,
				Properties( 0, {Transparency( 0 )}, Item ID( "0", 1 ) ),
				Properties( 1, {Transparency( 0.5 )}, Item ID( "1", 1 ) )
			)}
		)
	)
);

 

Here's a script for example 2: 

View more...

 

Graph Builder(
	Size( 518, 448 ),
	Show Control Panel( 0 ),
	Variables( X( :col ), Y( :row ), Color( :ParamC ), Color( :ParamA ) ),
	Elements(
		Heatmap( X, Y, Color( 1 ), Legend( 14 ) ),
		Heatmap( X, Y, Color( 2 ), Legend( 15 ) )
	),
	SendToReport(
		Dispatch( {}, "400", ScaleBox,
			{Legend Model(
				15,
				Properties( 0, {Transparency( 0 )}, Item ID( "0", 1 ) ),
				Properties(
					1,
					{Fill Color( 0 ), Fill Pattern( "triangle up" )},
					Item ID( "1", 1 )
				),
				Properties(
					-1,
					{Fill Color( 0 ), Fill Pattern( "triangle left" )},
					Item ID( "-1", 1 )
				)
			)}
		)
	)
);