cancel
Showing results for 
Show  only  | Search instead for 
Did you mean: 
Try the Materials Informatics Toolkit, which is designed to easily handle SMILES data. This and other helpful add-ins are available in the JMP® Marketplace
Choose Language Hide Translation Bar
belikin23
Level I

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

 

belikin23_0-1695325892581.png

 

2 REPLIES 2
hogi
Level XII

Re: Cell plot question

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

 

hogi_0-1695328682657.png

 

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" )
		)
	)
)
txnelson
Super User

Re: Cell plot question

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

txnelson_0-1695334829535.png

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