Our World Statistics Day conversations have been a great reminder of how much statistics can inform our lives. Do you have an example of how statistics has made a difference in your life? Share your story with the Community!
Choose Language Hide Translation Bar
Highlighted
bzanos
Level II

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
Highlighted
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
Highlighted
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

Highlighted
bzanos
Level II

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

works great. Thanks

Article Labels