nav[aria-label="Primary Navigation"] { padding: 0; & ul { list-style: none; width: 100%; display: flex; flex-direction: row; justify-content: start; align-items: start; gap: 30px; padding: 0; & li { margin: 0; } & ul li { list-style: none; } } }

color settings for "missing" values

hogi

If there is a value missing in the data table, "missing" shows up as the first entry in the legend - and shifts all colors by 1

Is it possible to define the value order in the column preferences such that "missing" is last?

Is it possible to define this as a standard via preferences?

Or even better: Is it possible to define a fixed color for "missing" values - such that it doesn't interfere at all with the standard color order?

dt = Open( "$SAMPLE_DATA/Big Class.jmp" );

dt << Graph Builder(
	Size( 534, 464 ),
	Show Control Panel( 0 ),
	Graph Spacing( 4 ),
	Variables( X( :weight ), Y( :height ), Overlay( :sex ) ),
	Elements( Points( X, Y, Legend( 9 ) ), Smoother( X, Y, Legend( 10 ) ) )
);

wait(2);

dt:sex[5]="";

Accepted answers

txnelson

What you need to do is to set the Value Colors for the column in question. The limitation is that you do not want to use the #1 color in your choice. Reserve that for the Missing Category

names default to here(1);
dt = Open( "$SAMPLE_DATA/Big Class.jmp" );

:sex << set property("Value Colors", {"F" = "blue", "M" = "green"});

dt << Graph Builder(
	Size( 534, 464 ),
	Show Control Panel( 0 ),
	Graph Spacing( 4 ),
	Variables( X( :weight ), Y( :height ), Overlay( :sex ) ),
	Elements( Points( X, Y, Legend( 9 ) ), Smoother( X, Y, Legend( 10 ) ) )
);

wait(2);

dt:sex[5]="";

All comments

jthi

You could use Value Colors column property but... if you use it it seems like the missing value color in the theme will be ignored. I would say this is a bug and should be reported to JMP support.

By default the user's preference color theme should be used AND the missing values should be with the desired color, but for some reason this doesn't seem to be the case

With Value Colors (missing color will be ignored)

Without Value Colors (weird shift as the missing color is used but first color is still skipped)

I'm using Universal color theme here

txnelson

Apparently you have the option, "Include Missing Categories" selected as your default. You can tun this off by unselecting it under the red triangle.

Or the option can be set as a default as a preference

The order of Missing Categories can also be adjusted under the "Legend Settings" selection under the red triangle

hogi

Hi Jim,

thanks for the explanations.

To be honest, I don't understand which part of it solves my problem:

and shifts all colors by 1

I face this problem very often in JMP and want to solve it in general.

Below is another example, which makes the problem slightly more visible:

"sex" and "sex_2" are "the same", there is just one value missing in one cell of the data table.

I expect the color schemes to be the same (*) "by default" - without any additional effort.

How can I configure JMP to make it behave like expected (*)?

dt = Open( "$SAMPLE_DATA/Big Class.jmp" );

dt << New Column( "sex_2", Character, set each value( :sex ) );

New Window( "compare",
	H List Box(
		dt << Graph Builder(
			Size( 534, 464 ),
			Show Control Panel( 0 ),
			Graph Spacing( 4 ),
			Variables( X( :weight ), Y( :height ), Overlay( :sex ) ),
			Elements( Points( X, Y, Legend( 9 ) ), Smoother( X, Y, Legend( 10 ) ) )
		), 

		dt << Graph Builder(
			Size( 534, 464 ),
			Show Control Panel( 0 ),
			Graph Spacing( 4 ),
			Variables( X( :weight ), Y( :height ), Overlay( :"sex_2" ) ),
			Elements( Points( X, Y, Legend( 9 ) ), Smoother( X, Y, Legend( 10 ) ) )
		)
	)
);



Wait( 2 );

dt:sex[5] = "";

dt = Open( "$SAMPLE_DATA/Big Class.jmp" ); dt << New Column( "sex_2", Character, set each value( :sex ) ); New Window( "compare", H List Box( dt << Graph Builder( Size( 534, 464 ), Show Control Panel( 0 ), Graph Spacing( 4 ), Variables( X( :weight ), Y( :height ), Overlay( :sex ) ), Elements( Points( X, Y, Legend( 9 ) ), Smoother( X, Y, Legend( 10 ) ) ) ), dt << Graph Builder( Size( 534, 464 ), Show Control Panel( 0 ), Graph Spacing( 4 ), Variables( X( :weight ), Y( :height ), Overlay( :"sex_2" ) ), Elements( Points( X, Y, Legend( 9 ) ), Smoother( X, Y, Legend( 10 ) ) ) ) ) ); Wait( 2 ); dt:sex[5] = "";

txnelson

What you need to do is to set the Value Colors for the column in question. The limitation is that you do not want to use the #1 color in your choice. Reserve that for the Missing Category

names default to here(1);
dt = Open( "$SAMPLE_DATA/Big Class.jmp" );

:sex << set property("Value Colors", {"F" = "blue", "M" = "green"});

dt << Graph Builder(
	Size( 534, 464 ),
	Show Control Panel( 0 ),
	Graph Spacing( 4 ),
	Variables( X( :weight ), Y( :height ), Overlay( :sex ) ),
	Elements( Points( X, Y, Legend( 9 ) ), Smoother( X, Y, Legend( 10 ) ) )
);

wait(2);

dt:sex[5]="";

hogi

Hi Jim,

you are right, this is indeed the most robust way to do it: minimum effort, but no surprises anymore

That was my first attempt to solve the issue, but ...

Ah:

What you need to do is to set the Value Colors for the column in question.
The limitation is that you do not want to use the #1 color in your choice. Reserve that for the Missing Category

Many thanks. Nice workaround for this secon-order issue

Next step:

Where is the column property setting hiding to define the "Value Markers"?

Quick Links