nav[aria-label="Primary Navigation"] { padding: 0; & ul { list-style: none; width: 100%; display: flex; flex-direction: row; justify-content: start; align-items: start; gap: 30px; padding: 0; & li { margin: 0; } & ul li { list-style: none; } } }

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

bgeaibreyi

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

Accepted answers

All comments

txnelson

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

bgeaibreyi

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

Sample Dataset.jmp

txnelson

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

bgeaibreyi

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

jules

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.

@jules

Sample Dataset - formula.jmp

bgeaibreyi

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

txnelson

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 )
);