nav[aria-label="Primary Navigation"] { padding: 0; & ul { list-style: none; width: 100%; display: flex; flex-direction: row; justify-content: start; align-items: start; gap: 30px; padding: 0; & li { margin: 0; } & ul li { list-style: none; } } }

Help with Overlay Plot by Get Column Names

AndresGlez

Hi all, hope somebody can help me.

I need to create a chart where in the number of numeric columns changes time to time, but at the end I need to plot all my numeric columns in Overlay plot as shown in below script.

Names Default To Here( 1 );
dt = Open( "$SAMPLE_DATA/Big Class.jmp" );
Overlay Plot( X( :name ), Y( :height, :weight ), Connect Thru Missing( 1 ) );

This is what I have tried but charts are created separated, I am wondering hot to accept the instruction for the Y axis. Thanks in advance.

dt = Data Table ("Big Class");
list = dt << get column names(numeric, continuous);
show (list);
For( i = 1, i <= N Items(list), i++,
Overlay Plot(
Y( Column( list[i] ) ),
X( :name ), Connect Thru Missing( 1 ) ) );

Accepted answers

The argument of Y(...) seems not to evaluated at runtime by the Overlay Plot platform.

Here's one way to force replace the list variable with an explicit list of columns before creating the plot:

dt = Open("$SAMPLE_DATA/Big Class.jmp");
list = dt << get column names(numeric, continuous);
op = Expr(
    Overlay Plot(Y((Expr(list))), X(:name), Connect Thru Missing(1))
);
Eval(Eval Expr(op));

ian_jmp

FYI, this also works:

myOP = dt << Overlay Plot(Y(dt << get column names(numeric, continuous)), X(:name), Connect Thru Missing(1));

gzmorgan0

Sorry, this still is not "crystal". When you refer to the first column, is that the fitrst column in the table or the first continuous column? Same question regarding the last 2 columns. Also, do you know the names of the columns you want to exclude? Should this be case sensitive?

I have a feeling, you might be asking how to skip certain columns. Not knowing exactly what you are looking for, here is an example that might help. nolist is a list of known names to skip.

Names Default to Here(1);

dt = Open("$sample_data/Semiconductor Capability.jmp");

cnames = dt << get column names("numeric", "String");
nolist = {"wafer", "site", "datetime"};

nw = New Window("Overlay Plots", lub = LineUpBox(ncol(3)));

For(i=1,i<=nitems(cnames), i++,
    if (contains(nolist, lowercase(cnames[i]) ), continue() ); //next i
    if( Col Number(column(cnames[i]) ) == 0 | Col Std Dev(column(cnames[i])) == 0, continue() );  //next i, no need to plot a constant.
	//otherwise
	vl = VlistBox(op = Overlay Plot(Y( Column(cnames[i])), X(:lot_id) ) );
	Report(op)[OutlineBox(1)] << set title("Overlay Plot: " || cnames[i] || " vs. lot_id");
	lub << append(vl);	
);

If you do not know the names to skip, you just know they are in certain positions in the table, create a nolist

//or create nolist

nolist = {};
Insert Into(nolist, Column(dt,1) << get name);
Insert Into(nolist, Column(dt, ncol(dt)-1) << get name);
Insert Into(nolist, Column(dt, ncol(dt)) << get name);
show(nolist);

You can also remove these names from cnames. [I am not sure exactly where these positions come from.] If you just wanted to remove the 1 and the last 2 continuous columns, simply get all continuous columns as show in the script, then

cnames = cnames[ 2::nitems(cnames)-2 ];&nbsp;

now cnames no longer have those values.

All comments

The argument of Y(...) seems not to evaluated at runtime by the Overlay Plot platform.

Here's one way to force replace the list variable with an explicit list of columns before creating the plot:

dt = Open("$SAMPLE_DATA/Big Class.jmp");
list = dt << get column names(numeric, continuous);
op = Expr(
    Overlay Plot(Y((Expr(list))), X(:name), Connect Thru Missing(1))
);
Eval(Eval Expr(op));

ian_jmp

FYI, this also works:

myOP = dt << Overlay Plot(Y(dt << get column names(numeric, continuous)), X(:name), Connect Thru Missing(1));

AndresGlez

This is also a different approach,

thank you for the support @ian_jmp and @ms

gzmorgan0

There are 2 good solutions to your question. I am adding this as an FYI, for a 3rd alternative.

i like to work with the column names as text. When you have a list of column names (string) certain platforms (not all) require Eval List(), so I suggest to use it pro forma (a standard).

dt = Open("$SAMPLE_DATA/Big Class.jmp");
mylist = dt << get column names(numeric, continuous, string);
op = Overlay Plot(Y(EvalList(mylist)), X(:name), Connect Thru Missing(1));