Color Tabulate report based on other column value

Hamal22 — Sat, 10 Jun 2023 23:52:07 GMT

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

Re: Color Tabulate report based on other column value

jthi — Mon, 01 Aug 2022 08:45:05 GMT

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 ,

topic Re: Color Tabulate report based on other column value in Discussions

Color Tabulate report based on other column value

Re: Color Tabulate report based on other column value