Auto-suggest helps you quickly narrow down your search results by suggesting possible matches as you type.

- Subscribe to RSS Feed
- Mark Topic as New
- Mark Topic as Read
- Float this Topic for Current User
- Bookmark
- Subscribe
- Printer Friendly Page

Highlighted

- Mark as New
- Bookmark
- Subscribe
- Mute
- Subscribe to RSS Feed
- Get Direct Link
- Email to a Friend
- Report Inappropriate Content

Sep 22, 2020 6:24 AM
(151 views)

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

1 ACCEPTED SOLUTION

Accepted Solutions

Highlighted

- Mark as New
- Bookmark
- Subscribe
- Mute
- Subscribe to RSS Feed
- Get Direct Link
- Email to a Friend
- Report Inappropriate Content

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

2 REPLIES 2

Highlighted

- Mark as New
- Bookmark
- Subscribe
- Mute
- Subscribe to RSS Feed
- Get Direct Link
- Email to a Friend
- Report Inappropriate Content

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

Highlighted
##

- Mark as New
- Bookmark
- Subscribe
- Mute
- Subscribe to RSS Feed
- Get Direct Link
- Email to a Friend
- Report Inappropriate Content

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

works great. Thanks