topic How to add N Missing in caption box on graph builder in Discussions

How to add N Missing in caption box on graph builder

SophieCuvillier — Thu, 20 Nov 2025 17:37:06 GMT

Hello,

I'm using Graph builder and I would like to add the number of missing values in the caption box on my graph builder, but is is not a statistic available. I am missing something or is there another way to add it ? Ideally in click-button.

I'm in JMP 19

Names Default To Here( 1 );
dt = Open( "$SAMPLE_DATA/Big Class.jmp" );
Graph Builder(
	Size( 659, 446 ),
	Show Control Panel( 0 ),
	Variables( X( :sex ), Y( :height ) ),
	Elements(
		Points( X, Y, Legend( 3 ) ),
		Caption Box(
			X,
			Y,
			Legend( 4 ),
			Summary Statistic( "Mean" ),
			Summary Statistic 2( "5 Number Summary" ),
			Location( "Axis Table" )
		)
	)
);

Re: How to add N Missing in caption box on graph builder

hogi — Thu, 20 Nov 2025 21:42:09 GMT

nasty workaround:
You can add a second caption - and use a special transform column to mark the missing rows.

A disadvantage:
it shows the number of missing entries as "N" (as we use this summary statistics) instead of N missing.

Names Default To Here( 1 );
dt = Open( "$SAMPLE_DATA/Big Class.jmp" );
dt[[5,8,13], "height"]=[.,.,.];
Graph Builder(
	Transform Column( "missing", Formula( If( Is Missing( :height ), 1, . ) ) ),
	Size( 397, 341 ),
	Show Legend( 0 ),
	Graph Spacing( 4 ),
	Variables( X( :sex ), Y( :height ), Y( :missing, Position( 1 ) ) ),
	Elements(
		Points( X, Y( 1 ) ),
		Caption Box( X, Y( 1 ),  Summary Statistic( "Mean" ),
		Summary Statistic 2( "N" ),
		 Location( "Axis Table" ) ),
		Caption Box( X, Y( 2 ),  Summary Statistic( "N" ), Location( "Axis Table" ) )
	)
);

Re: How to add N Missing in caption box on graph builder

hogi — Thu, 20 Nov 2025 21:42:39 GMT

Shouldn't all platforms provide the same set of aggregations?
When a program gives you a feature in one spot but hides it in another, you end up feeling weirdly jealous of yourself.

If this makes sense to you, please vote: