BookmarkSubscribeRSS Feed
Choose Language Hide Translation Bar
bgeaibreyi
Community Trekker

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

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

0 Kudos
8 REPLIES 8
txnelson
Super User

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
0 Kudos
bgeaibreyi
Community Trekker

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

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

Run Chart Screenshot.PNG

0 Kudos
Highlighted
julian
Staff

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. 

@julian 

bgeaibreyi
Community Trekker

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

0 Kudos
txnelson
Super User

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

run.PNG

Jim
0 Kudos
bgeaibreyi
Community Trekker

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

0 Kudos
txnelson
Super User

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.

2x2.PNG

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
0 Kudos
bgeaibreyi
Community Trekker

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! 

0 Kudos