cancel
Showing results for 
Show  only  | Search instead for 
Did you mean: 

Discussions

Solve problems, and share tips and tricks with other JMP users.
Choose Language Hide Translation Bar

How to add N Missing in caption box on graph builder

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" )
		)
	)
);
2 REPLIES 2
hogi
Level XIII

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

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.

hogi_0-1763674624283.png

 

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

 

hogi
Level XIII

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

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: Please synchronize Summary Statistics (Tables/Summary - Tabulate - Graph Builder Summary Statistics ... 

Recommended Articles