topic RGB color by sript in Discussions

RGB color by sript

Dennisbur — Wed, 03 Apr 2024 17:02:33 GMT

Hello
I would like to color column "Name" and to use RGB
but recive mistake, what's wrong I did in this script?

dt = Current Data Table();

rows_to_color = dt << Get Rows Where (:"NAME" == :"NAME");
Column(dt, "NAME") << Color Cells (RGB ( 173, 255, 47 ), rows_to_color);

Re: RGB color by sript

jthi — Wed, 03 Apr 2024 17:11:52 GMT

What are you trying to do with this comparison dt << Get Rows Where (:"NAME" == :"NAME")? Get list of all rows or something else? Also I don't think JMP has RGB named argument for Color Cells (you can get those colors, but it requires a bit more work)

https://www.jmp.com/support/help/en/17.2/#page/jmp/color-cells.shtml#ww725145

https://www.jmp.com/support/help/en/17.2/#page/jmp/graphics-functions.shtml?os=win&source=application#ww2650608

Re: RGB color by sript

Dennisbur — Wed, 03 Apr 2024 17:44:23 GMT

Hello

I mean, for example, I would like to paint the columns

and mostly, I use names of color like "Light Red"

for example, to color the column HOT

rows_to_color = dt << Get Rows Where(:"HOT" == :"HOT");

Column(dt, "HOT") << Color Cells("Light Red", rows_to_color);

But I believe I can use more shades of color, maybe like RGB code?

Re: RGB color by sript

jthi — Wed, 03 Apr 2024 18:02:51 GMT

Yes you can. You can convert RGB colors to "JMP Colors" using RGB Color function. Below is an example

Names Default To Here(1); 

dt = open("$SAMPLE_DATA/Big Class.jmp");

// lawngreen
Column(dt, "age") << Color Cells(RGB Color({124, 252, 0}/255));

Re: RGB color by sript

pmroz — Wed, 03 Apr 2024 18:22:29 GMT

Rather than use "get rows where", might be easier to create a matrix of all row numbers.

dt = New Table( "Test Color", Add Rows( 5 ),
	New Column( "Column 1", Numeric, "Continuous", Format( "Best", 12 ),
		Set Values( [1, 2, 3, 4, 5] ) )
);
// Create a matrix of rows 1 to n
rows_to_color = 1::nrows(dt);
// Set the color
dt:Column 1 << color cells("Red", rows_to_color);

Re: RGB color by sript

Mark_Bailey — Wed, 03 Apr 2024 19:13:47 GMT

You can also supply a list of RGB values instead of a name or index value.

Column(dt, "age") << Color Cells( { 1, 1, 0.8 } );  // light yellow