cancel
Showing results for 
Show  only  | Search instead for 
Did you mean: 
Try the Materials Informatics Toolkit, which is designed to easily handle SMILES data. This and other helpful add-ins are available in the JMP® Marketplace
Choose Language Hide Translation Bar
Neo
Neo
Level VI

Is it possible to show excluded row values on chart via JSL?

In my attached example data table (and box plot chart script inside), I would like to show the excluded row values as points (or Marker (29)) on the chart. These excluded rows do not necessary need to be excluded but should not participate in the Box Plot. Is this doable via JSL (I am on JMP 16.2)?

 

Perhaps using Show Excluded Rows (), but cannot get it to work as desired.

When it's too good to be true, it's neither
1 ACCEPTED SOLUTION

Accepted Solutions
Ressel
Level VI

Re: Is it possible to show excluded row values on chart via JSL?

I think you can. See the attached example, created using Plot Excluded and Unhidden data points in Graph Builder.

The excluded points are shaded in the table script I've added to the table.

Ressel_0-1698229866890.png

 

Comparing side by side, the width of the boxes in the box plot are not influenced by the shaded, i.e., excluded & unhidden data.

 

Ressel_1-1698230097188.png

 

It looks to me that this is what you want?

View solution in original post

3 REPLIES 3
jthi
Super User

Re: Is it possible to show excluded row values on chart via JSL?

Almost anything is possible using JSL in JMP, so it isn't could you but rather should you. To use Show Excluded Rows() you would have to add points to your graph in one way or another AND you cannot locally exclude the already excluded values using Local Data Filter

-Jarmo
Ressel
Level VI

Re: Is it possible to show excluded row values on chart via JSL?

I think you can. See the attached example, created using Plot Excluded and Unhidden data points in Graph Builder.

The excluded points are shaded in the table script I've added to the table.

Ressel_0-1698229866890.png

 

Comparing side by side, the width of the boxes in the box plot are not influenced by the shaded, i.e., excluded & unhidden data.

 

Ressel_1-1698230097188.png

 

It looks to me that this is what you want?

Neo
Neo
Level VI

Re: Is it possible to show excluded row values on chart via JSL?

@Ressel Exactly. Thanks

When it's too good to be true, it's neither