topic Re: JSL to plot graph with last N values of a column in Discussions

JSL to plot graph with last N values of a column

bzanos — Fri, 09 Jun 2023 23:38:26 GMT

I am writing script to plot graph with last 10 values of a column. Below is the script I use which I learned from previous post.

It works. But I notice the this wording " Where( Row() > (n - last n) ) " appear in the graph which I do not want it to show.

Is there a way to remove this wording? or Is there other way to write JSL script to plot graph with last N values of a column?

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

last n = 10;
n = N Row( dt );

biv = dt << Bivariate(
	Y( :weight ),
	X( :height ),
	Where( Row() > (n - last n) )
);

Re: JSL to plot graph with last N values of a column

txnelson — Tue, 22 Sep 2020 13:34:28 GMT

Here is a quick example. It was just recently covered in a Discussion Here

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

last n = 10;
n = N Row( dt );

biv = dt << Bivariate(
	Y( :weight ),
	X( :height ),
	Where( Row() > (n - last n) )
);
(report(biv)<<topparent)[textbox(1)]<<delete;

Re: JSL to plot graph with last N values of a column

bzanos — Tue, 22 Sep 2020 13:44:34 GMT

works great. Thanks