topic How to use JSL to color local cells by value? in Discussions

How to use JSL to color local cells by value?

lwx228 — Fri, 09 Jun 2023 23:31:11 GMT

For example, in the "weight" column of "Big class.jMP ", take the data in rows 1-10 and make the gradient color by data height, as in the Image.So can start and stop any color want.

Re: How to use JSL to color local cells by value?

lwx228 — Sun, 05 Jul 2020 14:15:45 GMT

"Color scales" were not found on the script index.

Thanks!

Re: How to use JSL to color local cells by value?

txnelson — Sun, 05 Jul 2020 19:05:16 GMT

Here is a script that will color the column weight's first 10 rows in the data table.

names default to here(1);
dt=Open("$SAMPLE_DATA/big class.jmp");

// Set the gradient list of colors
colorList = {-2768895, -5530606, -6582759, -8094941, -9147350, -10462158, -11514567, -12237762,
-13344414, -14575206};

// Color first 10 rows

// find the range
weightMin= col min(if(Row()<=10,:weight,.));
weightMax= col max(if(Row()<=10,:weight,.));
weightInc= (weightMax-weightmin)/10;

// Loop across and set the colors
For(i=1,i<=10,i++,
	Bin=floor((:weight[i]-weightMin)/weightInc)+1;
	if(Bin>10,Bin=10);
	:weight << color cells( colorList[bin],i)
);

To understand all of the concepts behind the colors in JMP, you need to read the documentation in the Scripting Guide on Specifying Colors

Re: How to use JSL to color local cells by value?

lwx228 — Mon, 06 Jul 2020 08:21:39 GMT

Thank Jim!

I searched the index and saw only this.
Where I can see a more complete color code?

Re: How to use JSL to color local cells by value?

txnelson — Mon, 06 Jul 2020 10:07:31 GMT

Look in the Scripting Guide.......not just the Scripting Index

Re: How to use JSL to color local cells by value?

pmroz — Mon, 06 Jul 2020 18:56:46 GMT

You can also try color gradient.

dt = open("$sample_data\Big Class.jmp");

bmin = col min(dt:height);
bmax = col max(dt:height);
bavg = col mean(dt:height);

dt:height << set property("Color Gradient", {"Light Spectral", Range( {bmin, bmax, bavg} )});
dt:height << Color Cell by Value(1);

This will color the entire column. You can use color cells for rows 11 to the end to remove the color.

Re: How to use JSL to color local cells by value?

lwx228 — Tue, 07 Jul 2020 14:40:58 GMT

Thank pmroz!

Is your code complete?I didn't see any results when I ran it, and I didn't know how to perfect the code.Thanks for your help!

Re: How to use JSL to color local cells by value?

pmroz — Tue, 07 Jul 2020 14:52:08 GMT

You should see this:

Re: How to use JSL to color local cells by value?

pmroz — Tue, 07 Jul 2020 14:56:45 GMT

Here's how to only show the color gradient for rows 1-10. Note that the min, max and mean are calculated on the entire column. You can adjust that.

dt = open("$sample_data\Big Class.jmp");

bmin = col min(dt:height);
bmax = col max(dt:height);
bavg = col mean(dt:height);

dt:height << set property("Color Gradient", {"Light Spectral", Range( {bmin, bmax, bavg} )});
dt:height << Color Cell by Value(1);

reset_rows = 11::40;
dt:height << color cells ("White", reset_rows);

Re: How to use JSL to color local cells by value?

lwx228 — Tue, 07 Jul 2020 22:50:21 GMT

Thank pmroz!

Strange, I still don't see 1-10 lines of color here.Lines 11 to 40 are white.

Re: How to use JSL to color local cells by value?

lwx228 — Tue, 07 Jul 2020 22:53:55 GMT

The same is true with other versions.

Re: How to use JSL to color local cells by value?

pmroz — Wed, 08 Jul 2020 14:55:43 GMT

What OS and JMP version(s) are you using? I'm using JMP 14 on Windows 10, 64-bit.

Try these steps:

Open Big Class
Right click on height > Column Properties > Color Gradient

Check "Color Cell by Value", then OK

You should end up with this:

If this still doesn't work you'll need to contact the JMP helpdesk.

Re: How to use JSL to color local cells by value?

lwx228 — Wed, 08 Jul 2020 23:05:16 GMT

Thank pmroz!

I did it.

Re: How to use JSL to color local cells by value?

lwx228 — Wed, 08 Jul 2020 23:58:48 GMT

But to do it manually in order to show this?

In addition, could use JSL to automatically get the color number of each row cell in the column of "height"?

Re: How to use JSL to color local cells by value?

txnelson — Thu, 09 Jul 2020 00:04:27 GMT

A few years ago I asked the same question,

Here it is:

You basically have to extract it from the extracted script for the column you are interested in

Re: How to use JSL to color local cells by value?

lwx228 — Thu, 09 Jul 2020 00:24:49 GMT

Thank Jim!
You have given me a lot of help and have made rapid progress.

I used to use VBA, and I was able to record most of the code for each step.
Now using JSL, also want to achieve fully automatic operation.

Re: How to use JSL to color local cells by value?

lwx228 — Thu, 09 Jul 2020 00:47:18 GMT

Recording each step of operation, VBA is relatively easy.

Re: How to use JSL to color local cells by value?

txnelson — Thu, 09 Jul 2020 13:22:49 GMT

You can easily create a similar pattern in JSL. But in JSL you create Functions.

Re: How to use JSL to color local cells by value?

lwx228 — Fri, 10 Jul 2020 01:01:41 GMT

Thank Jim!

I still haven't learned to write "Functions".
I want to get a color number like this:

Re: How to use JSL to color local cells by value?

txnelson — Fri, 10 Jul 2020 02:55:03 GMT

Did you read the entry that I posted in my previous reply about how to retrieve Cell Colors? It has a function that can provide you with how to access the cell colors. If the colors have been set by the use of "Color or Mark by Column" then the only way I know to get the colors, is to create a rowstate column, copy the current rowstates to the new column, and then use the Color Of( Row State( row#)) to retrieve the color value.