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 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?
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.
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.
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
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.
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, it'd look nicer in a grid style but this might well do what I need depending on the visualization effect.
Thanks a lot!