cancel
Showing results for 
Show  only  | Search instead for 
Did you mean: 
  • Image to Table JMP extension imports single or batch images as data tables. Useful to extract curves from pictures or convert image data to curve data to use in analyses like Functional Data Explorer. Download and install the extension.

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