cancel
Showing results for 
Show  only  | Search instead for 
Did you mean: 
Try the Materials Informatics Toolkit, which is designed to easily handle SMILES data. This and other helpful add-ins are available in the JMP® Marketplace
Choose Language Hide Translation Bar
hogi
Level XII

Heatmap: color for Missing Values?

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)

 

hogi_0-1683319041752.png


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" );



 

4 REPLIES 4
Phil_Kay
Staff

Re: Heatmap: color for Missing Values?

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

hogi
Level XII

Re: Heatmap: color for Missing Values?

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

hogi
Level XII

Re: Heatmap: color for Missing Values?

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

hogi_1-1707036103207.png


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 ...

hogi
Level XII

Re: Heatmap: color for Missing Values?

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)