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" )
)
)
);
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" ) )
)
);
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 - Distribution - Header Statistics)
