turn on suggestions

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

Showing results for

- JMP User Community
- :
- Discussions
- :
- Discussions
- :
- Normalize data by overlay in Graph Builder with lo...

Topic Options

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

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

May 20, 2016 9:02 AM
(1976 views)

I have a graph I'm making in graph builder (I could use bivariate too) and using a local data filter.

I'm wondering if there's a way to auto-normalize these graphs so that they're on the same scale? I tried to do the range scale, but it doesn't seems to take into account the overlay or the local data filter from what I can tell.

Currently I do this:

local data filter, subset

make a column that divides column by its own col max with overlay as the by

plot new column

Thank you,

Vince

1 ACCEPTED SOLUTION

Accepted Solutions

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

May 20, 2016 1:26 PM
(2352 views)

Solution

If I'm reading this correctly, I think this will give you what you are looking for:

1. Modify the Range Scale formula to include your overlay variable as your By group variable and then add the Excluded() argument. See below example from the Semiconductor Capability sample data table using the NPN1 column with SITE as the by variable :

2. Use the Global Data Filter to filter the NPN1 (or your Y) variable. Be sure to check the "Show" and "Include" boxes on the Global Filter. This will change the Range Scaled column data result to reflect the filtered range of your Y variable.

The Local Data Filter will not work since you need the filter to work on the table and the graph.

Hope that helps.

-Jerry

5 REPLIES

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

May 20, 2016 9:19 AM
(1797 views)

If I am interpreting your question accurately, what I think you want, is to standardize the data, and then graph all of the data on the same graph. You can do this by passing all of the columns you want to graph through the Distribution platform, and then to select the red triangle option of Save==>Standardized. You can then go to Graph Builder and select all of the standardized columns and drag them to your Y axis.

Jim

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

May 20, 2016 9:46 AM
(1797 views)

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

May 20, 2016 10:36 AM
(1797 views)

No sorry. I have 1 column of Ys that I'm overlaying by some by column. I'm using a local data filter to select out only some of the data.

I'm trying to make the Y profiles of each group to be on the same scale.

Trying to make this:

Go to this:

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

May 20, 2016 1:26 PM
(2353 views)

If I'm reading this correctly, I think this will give you what you are looking for:

1. Modify the Range Scale formula to include your overlay variable as your By group variable and then add the Excluded() argument. See below example from the Semiconductor Capability sample data table using the NPN1 column with SITE as the by variable :

2. Use the Global Data Filter to filter the NPN1 (or your Y) variable. Be sure to check the "Show" and "Include" boxes on the Global Filter. This will change the Range Scaled column data result to reflect the filtered range of your Y variable.

The Local Data Filter will not work since you need the filter to work on the table and the graph.

Hope that helps.

-Jerry

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

May 20, 2016 1:42 PM
(1797 views)