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

- JMP User Community
- :
- Discussions
- :
- RE: Graphing or Analysis Platform that assumes x-axis 1,2,3,4......

- 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

RE: Graphing or Analysis Platform that assumes x-axis 1,2,3,4......

Jul 8, 2019 9:45 AM
(1779 views)

Hello,

I'm trying to plot data from different rows by different categories from a large data table. Is there any JMP features or platform that can automatically assume x-axis to be 1,2,3,4...... while displaying all the numeric values on the 7-axis? Assuming row numbers is not very helpful in this scenario.

Thanks,

Gary

8 REPLIES 8

Highlighted
##

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

RE: Graphing or Analysis Platform that assumes x-axis 1,2,3,4......

Your request is confusing to me. Could you please provide a sample data table, and a sample of your output.

Jim

Highlighted
##

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

RE: Graphing or Analysis Platform that assumes x-axis 1,2,3,4......

Created:
Jul 8, 2019 1:55 PM
| Last Modified: Jul 8, 2019 2:12 PM
(1761 views)
| Posted in reply to message from txnelson 07-08-2019

Hi Jim,

Thanks for getting back to me and sorry for the confusion. Here's a sample data table with a saved graph builder script and a screenshot. I'm trying to put together some sort of run chart visualization however the column circled in red is not available in my working data table. If I only have column "model" and "value", is there any platform that can visualize as shown?

Thanks,

Gary

Highlighted
##

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

RE: Graphing or Analysis Platform that assumes x-axis 1,2,3,4......

Hi @bgeaibreyi

You mention that you don't have the column "Data #" in your working data table. Is there anything stopping you from making it? It looks like it's simply a count of the occurrences of each data point within Model, which you could make with the following column formula:

Col Cumulative Sum( 1, :Model )

With that column, you would be able to create the graph as you have before. Otherwise, Jim's suggestion is a great one.

Highlighted
##

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

RE: Graphing or Analysis Platform that assumes x-axis 1,2,3,4......

Hi Julian,

Thanks for the suggestion and it's a great one. However, there's more filtering I'll have to do that I'd have to reset "1, 2, 3...." every time I redefine the filter. The run chart works great but I need to find a way to convert to the subplot grid style.

Gary

Highlighted
##

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

RE: Graphing or Analysis Platform that assumes x-axis 1,2,3,4......

What you are asking for appears to be a Run Chart created for each Model. By default, it does not create the charts in a 2x2 format, but it does create the 4 charts, without having to specify the X axis

Analyze==>Quality and Process==>Control Chart==>Run Chart

Specify Value as the Process Variable, and Model as the By Variable

Jim

Highlighted
##

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

RE: Graphing or Analysis Platform that assumes x-axis 1,2,3,4......

Thanks Jim,

This is helpful however I'm indeed looking for something that can put into 2X2 subplots style since I'm working something that I'm trying to do a 5X4.

Gary

Highlighted
##

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

RE: Graphing or Analysis Platform that assumes x-axis 1,2,3,4......

Here is a little script that will give you your requested Wrapped output, using the Runs Chart output. You can set the number of charts to be displayed, and it will output row after row, until all of the models are charted.

```
Names Default To Here( 1 );
dt = Current Data Table();
// Get the list of models in the data
Summarize( dt, theModels = By( :Model ) );
X = 2; // the number of graphs across
xCount = 0;
// Create the output window
NW = New Window( "Charts", Vlb = V List Box() );
// Create place to store a row of graphs
hlb = H List Box();
// Loop across all of the models and generate the graphs
For( i = 1, i <= N Items( theModels ), i++,
cc = Control Chart(
invisible,
Sample Size( 1 ),
KSigma( 3 ),
Chart Col( :Value, Run Chart( Show Center Line( 0 ) ) ),
Where( :Model == theModels[i] )
);
xCount = xCount + 1;
// Add the Model to the title of the graph
Report( cc )[Outline Box( 2 )] << set title(
(Report( cc )[Outline Box( 2 )] << get title) || " Model=" || theModels[i]
);
// Add the output to the row of graphs
hlb << append( Report( cc )[Outline Box( 2 )] );
// If this is the last graph for the row, then add the row of graphs
// to the output window
If( xCount == X,
xCount = 0;
Vlb << append( hlb );
hlb = H List Box();
);
);
// If the last row of graphs is not complete, it will not have been added
// to the output window, so check on it and if necessary, add it
If( xCount != 0,
Vlb << append( hlb )
);
```

Jim

Highlighted
##

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

RE: Graphing or Analysis Platform that assumes x-axis 1,2,3,4......

Jim, it'd look nicer in a grid style but this might well do what I need depending on the visualization effect.

Thanks a lot!

Article Labels

There are no labels assigned to this post.