cancel
Showing results for 
Show  only  | Search instead for 
Did you mean: 
Choose Language Hide Translation Bar
hogi
Level XI

exclude, but not "hide"

Hi,

I wanted to remove a data point from a fit - but still show it in a graph.

So I tried this:

dt = Open( "$SAMPLE_DATA/Companies.jmp" );

dt << Graph Builder(
	Variables( X( :"# Employ"n ), Y( :"Sales ($M)"n ) ),
	Elements( Points( X, Y, Legend( 3 ) ), Line Of Fit( X, Y, Legend( 5 ) ) )
);

dt  << Select Rows( [32] ) << Exclude;

According to the data table, row # 32 is marked "excluded" - but not "hidden" (just as expected):

Holger_1-1654628138114.png

but surprisingly *), the data point 383220 / 63438 is missing in the graph:

Holger_6-1654629290551.png

 

Does anybody else experience the same behavior on his/her computer?

Just on my PC? (JMP 16.2.0, Windows).

 

 

*) JMP Documentation:

Holger_3-1654628244907.png

https://community.jmp.com/t5/Learning-Library/Hiding-and-Excluding-Data/ta-p/271761

 

1 ACCEPTED SOLUTION

Accepted Solutions
jthi
Super User

Re: exclude, but not "hide"

At least in graph builder there is a hidden... option (hold shift while you press the red triangle) Show Excluded Rows. With this enabled you will see excluded rows with slightly different transparency

jthi_0-1654632444121.png

 

-Jarmo

View solution in original post

3 REPLIES 3
jthi
Super User

Re: exclude, but not "hide"

At least in graph builder there is a hidden... option (hold shift while you press the red triangle) Show Excluded Rows. With this enabled you will see excluded rows with slightly different transparency

jthi_0-1654632444121.png

 

-Jarmo
hogi
Level XI

Re: exclude, but not "hide"

nice post on the same topic:
https://community.jmp.com/t5/Discussions/excluded-datapoints-in-graph-builder/m-p/47050

 

(I did not find it in the beginning)

 

Jasean
Staff

Re: exclude, but not "hide"

Different platforms interpret row exclusion differently.  In Graph Builder, when you exclude a row, it does not show as a Points element.  However, you can create the same graph in Fit Y by X.  In that platform, excluded points are shown, but they are not used in the line fit.  You would need to explicitly hide the point to remove it from the Fit Y by X graph.