Cell plot question

Question

Is it possible to create something like this plot in JMP? i.e. categorical data sorted by "patient", WITH a percentage bar...I tried various options in cell plot and legacy chart modules without much success. I am using JMP Pro 14.3.0.TIA!!

txnelson · Answer

JMP 14 does not have % of Factor option.  However, you can still create the graph in JMP 14 by creating a new Column which represents the percent of the overlay group of the X group.

dt << New Column( "% of Factor",
	formula(
		Col Sum( :height, :age, :sex ) / Col Sum( :height, :age )
	),
	format( "Percent", 7, 1)
);

Names Default To Here( 1 );

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

dt << New Column( "% of Factor",
	formula(
		Col Sum( :height, :age, :sex ) / Col Sum( :height, :age )
	),
	format( "Percent", 7, 1)
);

dt = Graph Builder(
	Variables(
		X( :age ),
		Y( :Name( "% of Factor" ) ),
		Overlay( :sex )
	),
	Elements( Bar( X, Y, Legend( 9 ), Bar Style( "Stacked" ) ) )
);

hogi · Answer

I guess yes. Try Bar chart with style Stacked and summary Statistics "% of factor".
(I hope the options were available in Jmp 14 ...)

Open( "$SAMPLE_DATA/Smartphone OS.jmp" );

Graph Builder(
	Variables(
		X( :Year ),
		Y( :Market Share ),
		Overlay( :Operating System ),
		Frequency( :Market Share )
	),
	Elements(
		Bar(
			X,
			Y,
			Legend( 11 ),
			Bar Style( "Stacked" ),
			Summary Statistic( "% of Factor" )
		)
	)
)