cancel
Showing results for 
Show  only  | Search instead for 
Did you mean: 
Submit your abstract to the call for content for Discovery Summit Americas by April 23. Selected abstracts will be presented at Discovery Summit, Oct. 21- 24.
Discovery is online this week, April 16 and 18. Join us for these exciting interactive sessions.
Choose Language Hide Translation Bar
bzanos
Level III

JSL to plot graph with last N values of a column

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

Capture4.JPG 

 

1 ACCEPTED SOLUTION

Accepted Solutions
txnelson
Super User

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

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;
Jim

View solution in original post

2 REPLIES 2
txnelson
Super User

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

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;
Jim
bzanos
Level III

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

works great. Thanks