topic Heatmap not displaying cells with no data in Graph Builder in Discussions

Heatmap not displaying cells with no data in Graph Builder

JehoulH — Sun, 11 Jun 2023 11:18:12 GMT

Editor's Note: This topic was moved from a comment in . Please refer to this Wish List item for context.

Hi all,

I'd like to come back to this topic. I am trying to create a similar heatmap, but the cells that don't have values don't get a border, as you can also see in the example of Paul (row DH). Any suggestion how this can be achieved?

I'm using the heatmap to build a kind of wafer map that has 21 zones. I would like to border all the zones, but the problem is that for some zones there is no data. I already tried to fill in 0, but then it messes with the color gradient.

Looking forward to your reply.

Re: Bordered or Higher Contrast Heatmap in Graph Builder

JehoulH — Wed, 13 Oct 2021 11:12:21 GMT

Here is how it looks like, but due to entering 0 the colors of the actual datapoints are impacted. And if I don't put 0, the cells without data are not bordered:

Re: Bordered or Higher Contrast Heatmap in Graph Builder

ih — Wed, 20 Oct 2021 13:36:53 GMT

What color would you like the cells with no values to be, I'm guessing white? If so you could add gridlines to the axis and add the heatmap line color, then you should see every thing filled in:

Here is a script to recreate these values:

Names default to here(1);

dt = Open( "$Sample_data/big class.jmp" );

dt << Graph Builder(
	Size( 550, 482 ),
	Show Control Panel( 0 ),
	Variables( X( :height ), Y( :weight ) ),
	Elements( Heatmap( X, Y, Legend( 4 ) ) ),
	SendToReport(
		Dispatch(
			{},
			"height",
			ScaleBox,
			{Label Row(
				{Major Grid Line Color( 0 ), Minor Grid Line Color( 0 ),
				Show Major Grid( 1 ), Show Minor Grid( 1 )}
			)}
		),
		Dispatch(
			{},
			"weight",
			ScaleBox,
			{Label Row(
				{Major Grid Line Color( 0 ), Minor Grid Line Color( 0 ),
				Show Major Grid( 1 ), Show Minor Grid( 1 )}
			)}
		),
		Dispatch(
			{},
			"Graph Builder",
			FrameBox,
			{DispatchSeg( RectSeg( 1 ), Line Width( 1 ) )}
		)
	)
)

Re: Bordered or Higher Contrast Heatmap in Graph Builder

JehoulH — Mon, 25 Oct 2021 13:52:10 GMT

Hello ih,

Thanks for this suggestion, this is exactly what I'm looking for. However, for my case the grid lines are crossing the actual zones as you can see below:

Do you think there is a way to get the grid lines in between?

Re: Bordered or Higher Contrast Heatmap in Graph Builder

JehoulH — Mon, 25 Oct 2021 13:56:18 GMT

I actually just found the solution myself... change automatic to long divider! thanks for the tip!