Following up with this.
https://community.jmp.com/t5/Discussions/Automatic-Scaling-Matching-X-and-Y-Axes/m-p/762890#M94321
I discovered a flaw in the script whereby excluded rows are not plotted but still factor in the graph scaling. I need a way to eliminate those from y_there and x_there somehow.
dt = Current Data Table();
dt << Clear Column Selection();
colList = dt << get column names( string );
check_list = {"VT", "ID", "DI", "IK", "GM"};
New Window( "Select Variables",
<<MODAL></MODAL>
Help appreciated.
You can "pre-filter" your values, for example by getting non-excluded rows first
Names Default To Here(1);
dt = open("$SAMPLE_DATA/Big Class.jmp");
dt << Select Rows(Index(7, 11)) << Hide and Exclude(1);
non_excluded_rows = dt << get rows where(!Excluded());
m = Column(dt, "height") << get values;
valid_m = m[non_excluded_rows];
N Items(valid_m);
show(valid_m, N Items(valid_m));
</CODE></P>
<P> </P></LINGO-BODY><LINGO-SUB id="lingo-sub-800040" slang="en-US" mode="CREATE">Re: Auto Scaling</LINGO-SUB><LINGO-BODY id="lingo-body-800040" slang="en-US" mode="CREATE"><P>Nice script as usual! Some useful things for sure. Because my original script is not operating on columns directly and I'm using an associative array (I'm new to those) I can't obviously see where to interrupt my code to make the modification?</P></LINGO-BODY><LINGO-SUB id="lingo-sub-800042" slang="en-US" mode="CREATE">Re: Auto Scaling</LINGO-SUB><LINGO-BODY id="lingo-body-800042" slang="en-US" mode="CREATE"><P>If marker segment still has those rows but excluded, you should be able to use them in similar manner as you would for values you get from columns. And if they aren't even there, then there should be nothing to worry about. If necessary you could also utilize << Get Row Numbers with marker segment if it is available.</P>
<P> </P>
<P>Also maybe you could just utilize the columns, values stored in those and ignore marker segment as you know the column names.</P></LINGO-BODY><LINGO-SUB id="lingo-sub-800087" slang="en-US" mode="CREATE">Re: Auto Scaling</LINGO-SUB><LINGO-BODY id="lingo-body-800087" slang="en-US" mode="CREATE"><P>Jarmo</P><P> </P><P>I modified the script with your suggestions and it works except in a very isolated case where the data has an odd interdigitisation resulting from a transpose.</P><P> </P><PRE><CODE class=" language-jsl">dt = Current Data Table();
dt << Clear Column Selection();
colList = dt << get column names( string );
check_list = {"VT", "ID", "DI", "IK", "GM"};
New Window( "Select Variables",
<<MODAL></MODAL>
