cancel
Showing results for 
Show  only  | Search instead for 
Did you mean: 
  • Learn how to build custom Python data connectors and further customize JMP’s Data Connector Framework with the Python Data Connector Demo, available now in the JMP Marketplace!
  • See how to create experiments to support product design and ID useful product features. Register for June 12 webinar, 2pm US Eastern Time.

Discussions

Solve problems, and share tips and tricks with other JMP users.
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 XIII

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

Recommended Articles