Auto-suggest helps you quickly narrow down your search results by suggesting possible matches as you type.

- JMP User Community
- :
- Discussions
- :
- Coloring dot distributions indvidually by "Value Colors" property (or alternativ...

- Subscribe to RSS Feed
- Mark Topic as New
- Mark Topic as Read
- Float this Topic for Current User
- Bookmark
- Subscribe
- Printer Friendly Page

Highlighted

- Mark as New
- Bookmark
- Subscribe
- Mute
- Subscribe to RSS Feed
- Get Direct Link
- Email to a Friend
- Report Inappropriate Content

Created:
Jul 26, 2020 9:40 AM
| Last Modified: Jul 26, 2020 9:43 AM
(439 views)

I would like to plot the data distributions but coloring each variable individually.

Example:

I found the following property which encodes color base on max/min gradient or user specific data.

However, this might not the be the right approach.

The code for the example which I manually composed to explain the goal is here:

```
// Start of script;
Names Default To Here( 1 );
Clear Log();
dt = Open( "$SAMPLE_DATA/Bands Data.JMP" );
Graph Builder(
Size( 534, 456 ),
Show Control Panel( 0 ),
Variables(
Y( :viscosity, Combine( "Parallel Merged" ) ),
Y( :proof cut, Position( 1 ), Combine( "Parallel Merged" ) ),
Y( :blade pressure, Position( 1 ), Combine( "Parallel Merged" ) ),
Color( :viscosity )
),
Elements( Points( Y( 1 ), Y( 2 ), Y( 3 ), Legend( 10 ) ) )
)
```

1 ACCEPTED SOLUTION

Accepted Solutions

Highlighted

- Mark as New
- Bookmark
- Subscribe
- Mute
- Subscribe to RSS Feed
- Get Direct Link
- Email to a Friend
- Report Inappropriate Content

Is this kind of what you want?

It was created by subsetting each of the 3 columns of Viscosity, Proof Cut and Blade Pressure into 3 separate data tables. Then adding doing a Color and Mark by Column on the one column in each table, and indicating to Save to Column Property.

Next, I changed the name of the column to "Value", and then added a new column called "Type" and set each of the values in the data table to what type of measurement it was.......Viscosity, Proof Cut or Blade Pressure.

Finally I concatenated the 3 data tables together, and brought up Graph Builder , placing the Value column as the X variable, and the Y Grouping as the Type.

The script for the Graph Builder is below

```
Graph Builder(
Size( 531, 456 ),
Show Control Panel( 0 ),
Variables( X( :Value ), Group Y( :Type ) ),
Elements( Points( X, Legend( 5 ) ) ),
SendToReport(
Dispatch(
{},
"graph title",
TextEditBox,
{Set Text( "Viscosity, Proof Cut & Blade Presure" )}
)
)
);
```

Jim

4 REPLIES 4

Highlighted

- Mark as New
- Bookmark
- Subscribe
- Mute
- Subscribe to RSS Feed
- Get Direct Link
- Email to a Friend
- Report Inappropriate Content

Is this kind of what you want?

It was created by subsetting each of the 3 columns of Viscosity, Proof Cut and Blade Pressure into 3 separate data tables. Then adding doing a Color and Mark by Column on the one column in each table, and indicating to Save to Column Property.

Next, I changed the name of the column to "Value", and then added a new column called "Type" and set each of the values in the data table to what type of measurement it was.......Viscosity, Proof Cut or Blade Pressure.

Finally I concatenated the 3 data tables together, and brought up Graph Builder , placing the Value column as the X variable, and the Y Grouping as the Type.

The script for the Graph Builder is below

```
Graph Builder(
Size( 531, 456 ),
Show Control Panel( 0 ),
Variables( X( :Value ), Group Y( :Type ) ),
Elements( Points( X, Legend( 5 ) ) ),
SendToReport(
Dispatch(
{},
"graph title",
TextEditBox,
{Set Text( "Viscosity, Proof Cut & Blade Presure" )}
)
)
);
```

Jim

Highlighted
##

- Mark as New
- Bookmark
- Subscribe
- Mute
- Subscribe to RSS Feed
- Get Direct Link
- Email to a Friend
- Report Inappropriate Content

Re: Coloring dot distributions indvidually by "Value Colors" property (or alternative)

It does seem to do the trick, thanks.

Two small questions about this solution:

1. Can you script code the row colors?

2. Is there a way to dynamically link the two tables so when one value in the original column is selected the row of the concatenated is also highlighted?

Highlighted
##

- Mark as New
- Bookmark
- Subscribe
- Mute
- Subscribe to RSS Feed
- Get Direct Link
- Email to a Friend
- Report Inappropriate Content

Re: Coloring dot distributions indvidually by "Value Colors" property (or alternative)

Looking at your solution again, if one normalizes each column variable first then you can color them directly within graph builder.

Notice that the example worked because the ranges were similar.

The concatenated table can have two columns to keep all the information:

- Value (original)

- Normalized value (used for color)

The final question to accept the solution:

- How tall can a JMP table be?
- How to link with original table?

The alternative for the second point will be to:

a) show the original value as information when you are hovering your mouse

b) or create graphlet with a column filter that changes the plot (image above).

As this will be a very long table it should be a solution that does not make JMP struggle.

Highlighted
##

- Mark as New
- Bookmark
- Subscribe
- Mute
- Subscribe to RSS Feed
- Get Direct Link
- Email to a Friend
- Report Inappropriate Content

Re: Coloring dot distributions indvidually by "Value Colors" property (or alternative)

The size of a JMP table is limited by the amount of RAM memory you have. I have actually seen a demonstration with over a Billion rows.

Concerning linking, you can do a virtual link between tables, or you can use

Tables==>Join to put the data together. However, in JMP it is typical to have multiple tables for a giving analysis. The way JMP deals with that is to open a JMP Project, where you can place all of your tables and journals and charts, as well as items from outside the JMP domain.

Jim