topic Re: Heatmap: color for Missing Values? in Discussions

Heatmap: color for Missing Values?

hogi — Sun, 04 Feb 2024 08:37:44 GMT

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

Re: Heatmap: color for Missing Values?

Phil_Kay — Wed, 24 May 2023 12:13:06 GMT

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

Re: Heatmap: color for Missing Values?

hogi — Wed, 24 May 2023 15:38:52 GMT

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

Re: Heatmap: color for Missing Values?

hogi — Sun, 04 Feb 2024 19:38:10 GMT

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

Re: Heatmap: color for Missing Values?

hogi — Wed, 07 Feb 2024 03:20:25 GMT

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)