680263_en-US

liliconcom

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

 

 

Basic Data Analysis and ModelingRe: 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 ...)

 

 

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

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