topic Re: Cell plot question in Discussions

Cell plot question

belikin23 — Thu, 21 Sep 2023 19:55:09 GMT

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!!

Re: Cell plot question

hogi — Thu, 21 Sep 2023 20:38:55 GMT

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

Re: Cell plot question

txnelson — Thu, 21 Sep 2023 22:21:00 GMT

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