Heatmap: color for Missing Values?

[#1]

In Graph Builder, there is a special color ("Missing"), which is used if the entry of the color column is empty in the respective row.
Very convenient.

This functionality is enabled for Points, Bar, Heatmap and Treemap plots, if a column with modeling type ordinal or nominal is used.

This functionality is enabled for Points, Bar, and Treemap plots, if a column with modeling type continuous is used.

On the other hand, this functionality is not enabled by default for Heatmap plots if a column with modeling type continuous is used.

What do I have to do to enable it?

top part: Points (points with "missing" color)

bottom part: Heatmap (tiles with "missing" color are missing)

➥ Tiny-Traps-in-Jmp-and-JSL 

Names Default to Here(1);
dt = Open( "$SAMPLE_DATA/Big Class.jmp" );

dt << New Column( "one",<<Set Each Value( 1 ) );
	
dt:age[5::20]=.;

Graph Builder(
	Variables( X( :name ), Y( :one ), Y( :one ), Color( :age ) ),
	Elements(
		Position( 1, 1 ),
		Points( X, Y, Legend( 12 ), Jitter( "None" ) )
	),
	Elements( Position( 1, 2 ), Heatmap( X, Y, Legend( 7 ) ) ),
	SendToReport(
		Dispatch(
			{},
			"Graph Builder",
			FrameBox,
			{Marker Size( 20 ), Marker Drawing Mode( "Normal" )}
		)
	)
);

wait(2);

dt:age << Set Modeling Type( "Continuous" );

[#2]

Hi @hogi ,

I am sorry you have not received a response yet. I am guessing it is because no one has a solution.

I had a quick look and I can't see how to do it.

This is probably good question for technical support (email: support@jmp.com) and/or the JMP Wish List.

Sorry I could not provide more help,

Phil

[#3]

Oh, according to feedback from Support it's treated as a bug: TS-00042488

[#4]

update: In Jmp18, missing values will be displayed with color "missing":

Hm, I had some cases where ...
... the grass has a nice greenish color on the old side of the river

Maybe in a future release there is an option to select one of the two options ...

[#5]

Easy trick to get to the green grass on the old side (no heatmap cells for missing color):
Use a transform column 

x_helper = if(is missing(:color_col),., :x_col)