39254_en-US

liliconcom

Coloring cells in a Tabulate report

Is it possible to color cells in a Tabulate report based on the values in particular cells? I know you can do this in a JMP data table and you can make a Tabulate report into a data table but the customer would like to color the cells in the Tabulate report directly. I can't figure out a way of doing that.Can anyone help, please?

Re: Coloring cells in a Tabulate reportThanks Wendy, that's very helpful.


Re: Coloring cells in a Tabulate report

I don't think it is possible to color rows in Tabulate.  Below is a workaround that puts the data into a TableBox with colored cells.

Names Default To Here( 1 );
dt = Open( "$SAMPLE_DATA/Car Poll.jmp" );

temp = (dt << Tabulate(
 Show Control Panel( 0 ),
 Add Table(
  Column Table( Grouping Columns( :sex, :marital status ) ),
  Row Table( Grouping Columns( :country, :size ) )
 )
)) << Make Into Data Table;

Column( temp, "size" ) << Set Property(
 "Value Colors",
 {"Large" = 3, "Medium" = 5, "Small" = 7}
) << Color Cell by Value;
 
rpt = temp << Get As Report;
rpt[Table Box( 1 )] << Set Shade Alternate Rows( 1 ) << Set Column Borders( 1 ) <<
Set Underline Headings( 1 ); 

New Window( "Tabulate", rpt );