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

How to change range of Group Y data in Graph Buildfer

Dec 22, 2017 4:10 AM
(12470 views)

Group Y in a Graph Builder chart has grouped the data as ... 8-16, 16-24.... etc (Picture attached) whereas I want 20 to be a cut-off so that the effect can be shown of values <20 and >20. Is there a way to force JMP 13.2.1 to change the range, please? I have tried changing the 'Number of Levels..' but couldn't get 20 as the end of a range on Group Y.

Thanks

5 REPLIES 5

Highlighted
##

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

Re: How to change range of Group Y data in Graph Buildfer

I believe the easiest way to do this is to create a new column using Recode that groups the "Number of Levels" into exactly the groupings you want. To use Recode, you will have to temporally change the Number of Levels column in to a character column, while you do the recoding since you will want the grouping values to be displayed as something like ">15 <= 20". Here is a simple example using the Big Class sample data table, where I have recoded the Height column into the groupings I want.

Jim

Highlighted
##

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

Re: How to change range of Group Y data in Graph Buildfer

Thanks Nelson.

I could manually recode the data, but the manual recoding may be difficult for big data. As a different approach, I copied the column and tried to create a formula to create the groups, but the formula is only partially working for some reason (screenshot enclosed for BigClass data). Not sure if there is some mistake in the formula or if this approach is not possible. Thanks

Highlighted
##

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

Re: How to change range of Group Y data in Graph Buildfer

```
If( :height < 55,
"50-55",
If( :height < 60,
"55-60",
If( :height < 65,
"60-65",
"65-70"
)
)
)
```

Not sure exactly why your formula doesnt work but this simpler formula should do the job.

Regards,

Phil

Highlighted
##

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

Re: How to change range of Group Y data in Graph Buildfer

Thanks Phil.

The formula also worked after some correction (enclosed). I guess it was the 'first day at work' effect earlier.

Regards

Highlighted
##

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

Re: How to change range of Group Y data in Graph Buildfer

A further simplification of the formula is:

```
If(
:height < 55, "50-55",
:height < 60, "55-60",
:height < 65, "60-65",
"65-70"
)
```

Jim

Article Labels

There are no labels assigned to this post.