topic Re: exclude, but not "hide" in Discussions

exclude, but not "hide"

hogi — Sun, 11 Jun 2023 11:24:46 GMT

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):

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

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

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

*) JMP Documentation:

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

Re: exclude, but not "hide"

jthi — Tue, 07 Jun 2022 20:08:33 GMT

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

Re: exclude, but not "hide"

Jasean — Tue, 07 Jun 2022 20:08:36 GMT

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.

Re: exclude, but not "hide"

hogi — Thu, 30 Jun 2022 05:24:20 GMT

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)