cancel
Showing results for 
Show  only  | Search instead for 
Did you mean: 
Check out the JMP® Marketplace featured Capability Explorer add-in
Choose Language Hide Translation Bar
Hamal22
Level I

Color Tabulate report based on other column value

Hi,

I would like to Color Tabulate report based on other column value (if needed result is higher then the second column then color it)

or maybe create the Tabulate and then convert it to data table or summery table and color it.

is there a way to do so?

 

appreciate your support on this

1 REPLY 1
jthi
Super User

Re: Color Tabulate report based on other column value

I think you have to do this with scripting and it will be easiest to first run Tabulate (or maybe Summary is even easier), then get rows which you want to color and then color those rows in specific columns

 

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

// get rows to color
rows_to_color = dt << Get Rows Where(:height >= 65);

// color specific rows (rows_to_color) in specific column ("Age")
Column(dt, "Age") << Color Cells("Red", rows_to_color);

Edit: Here are some older topics about coloring cells Conditional formatting in a data table , Conditional formatting in a data table 

-Jarmo