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
- :
- Re: Graph Builder X-Y choice selection

- 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

Aug 16, 2018 6:40 PM
(3455 views)

Hi All,

I have the following problem whereby I have few Xs and Ys. Depending on product, not all the data I crunched from database has the same parameters. I am aware that I can just use drag/drop but I intend to do it using a simple script.

For eg. in Product A, my Ys are Strength, Tensile, Mass and Diameter which means that I don't have Force in my column. Here my X is Date.

And for eg. in Product B, my Ys are Strength, Tensile, Force and Diameter which means that I don't have Mass in my column. Here my X is Day.

How can I do it with this kind of flexibility whereby the script will autoplot those parameters that are presence.

```
Graph Builder(
Size( 1015, 727 ),
Variables(
X( :date ),
X( :day)
Y( :Strength ),
Y( :Tensile ),
Y( :Force ),
Y( :Mass ),
Y( :Diameter ),
```

Thank you.

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

You can easily script the stacking of the data table, where all of your Y variables are stacked into one column. If you then use it as your Y column, and the Label (Y Column Names ) as your Overlay, then you will get what you want, without having to have a long and complex version of the Graph Builder code.

Jim

3 REPLIES 3

Highlighted

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

You can easily script the stacking of the data table, where all of your Y variables are stacked into one column. If you then use it as your Y column, and the Label (Y Column Names ) as your Overlay, then you will get what you want, without having to have a long and complex version of the Graph Builder code.

Jim

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

Re: Graph Builder X-Y choice selection

Thanks, that's a good one, Jim. Never thought of it.

Highlighted
##

Question: Does this method work if a particular variable column itself missing in one of the product ?

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

Re: Graph Builder X-Y choice selection