cancel
Showing results for 
Show  only  | Search instead for 
Did you mean: 
The Discovery Summit 2025 Call for Content is open! Submit an abstract today to present at our premier analytics conference.
Get the free JMP Student Edition for qualified students and instructors at degree granting institutions.
Choose Language Hide Translation Bar
View Original Published Thread

exclude, but not "hide"

hogi
Level XII

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 XII


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.