cancel
Showing results for 
Show  only  | Search instead for 
Did you mean: 
The Discovery Summit 2025 Call for Content is open! Submit an abstract today to present at our premier analytics conference.
Choose Language Hide Translation Bar
aliegner1
Level IV

make all Bivariate plots into a column, rather than a row?

I have a single Y value and many X values I'm plotting and the resulting output is 100's of charts in a single row, needing to scroll left/right.

 

I'm scripting it to plot the X values from a group of columns.

 

How can I get this to display in a column instead?

 

dtWIDE= current data table();

ERplot = Bivariate(
	Y( :ER_avg),
	X( dtWIDE<<get column group( "Step2" )),
	<<{Arrange in Rows( 52 ), Order by Goodness of Fit},
	//invisible, //use this to speed up.
);
1 ACCEPTED SOLUTION

Accepted Solutions
txnelson
Super User

Re: make all Bivariate plots into a column, rather than a row?

Here is one way of handling it

txnelson_0-1645746501122.png

Names Default To Here( 1 );
// Open Data Table: semiconductor capability.jmp
// → Data Table( "semiconductor capability" )
dtWide = Open( "$SAMPLE_DATA/semiconductor capability.jmp" );
ERplot = fit group(
	Oneway( Y( :NPN1 ), X( dtWIDE<<get column group( "Processes" ) ) ),
	<<{Arrange in Rows( 1 )}
);

 

 

Jim

View solution in original post

5 REPLIES 5
txnelson
Super User

Re: make all Bivariate plots into a column, rather than a row?

Here is one way of handling it

txnelson_0-1645746501122.png

Names Default To Here( 1 );
// Open Data Table: semiconductor capability.jmp
// → Data Table( "semiconductor capability" )
dtWide = Open( "$SAMPLE_DATA/semiconductor capability.jmp" );
ERplot = fit group(
	Oneway( Y( :NPN1 ), X( dtWIDE<<get column group( "Processes" ) ) ),
	<<{Arrange in Rows( 1 )}
);

 

 

Jim
aliegner1
Level IV

Re: make all Bivariate plots into a column, rather than a row?

Morning, Well this *works* kinda.

 

Yes, it changes the output to a single column of plots, but the problem is now that they are oneway plots instead of bivariate plots. I can't figure out how to add fit lines and model Rsquared on a oneway...

frank_wang
Level IV

Re: make all Bivariate plots into a column, rather than a row?

Hi I'm not sure it's that can help you to sovle your problem.

I guess you want to change the window UI from one raw to a matrix.

If it correct, you can set parameter  <<{Arrange in Rows( 3 )} in JSL or select option in red triangle and change the format from a row to a matrix.

Names Default To Here( 1 );
dt = New Table( "Test" );
For( i = 1, i <= 100, i++,
	dt << New Column( "Col", Continuous, formula( Random Normal( 10, 1 ) ) )
);
dt << add rows( 30 );
dt<<Fit Group(
	Bivariate( Y( :Col ), X( :Col 2 ) ),
	Bivariate( Y( :Col ), X( :Col 3 ) ),
	Bivariate( Y( :Col ), X( :Col 4 ) ),
	Bivariate( Y( :Col ), X( :Col 5 ) ),
	Bivariate( Y( :Col ), X( :Col 6 ) ),
	Bivariate( Y( :Col ), X( :Col 7 ) ),
	Bivariate( Y( :Col ), X( :Col 8 ) ),
	Bivariate( Y( :Col ), X( :Col 9 ) ),
	Bivariate( Y( :Col ), X( :Col 10 ) ),
	Bivariate( Y( :Col ), X( :Col 11 ) ),
	Bivariate( Y( :Col ), X( :Col 12 ) ),
	Bivariate( Y( :Col ), X( :Col 13 ) ),
	Bivariate( Y( :Col ), X( :Col 14 ) ),
	Bivariate( Y( :Col ), X( :Col 15 ) ),
	Bivariate( Y( :Col ), X( :Col 16 ) ),
	Bivariate( Y( :Col ), X( :Col 17 ) ),
	Bivariate( Y( :Col ), X( :Col 18 ) ),
	Bivariate( Y( :Col ), X( :Col 19 ) ),
	Bivariate( Y( :Col ), X( :Col 20 ) ),
	Bivariate( Y( :Col ), X( :Col 21 ) ),
	Bivariate( Y( :Col ), X( :Col 22 ) ),
	Bivariate( Y( :Col ), X( :Col 23 ) ),
	Bivariate( Y( :Col ), X( :Col 24 ) ),
	Bivariate( Y( :Col ), X( :Col 25 ) ),
	Bivariate( Y( :Col ), X( :Col 26 ) ),
	Bivariate( Y( :Col ), X( :Col 27 ) ),
	Bivariate( Y( :Col ), X( :Col 28 ) ),
	Bivariate( Y( :Col ), X( :Col 29 ) ),
	Bivariate( Y( :Col ), X( :Col 30 ) ),
	Bivariate( Y( :Col ), X( :Col 31 ) ),
	Bivariate( Y( :Col ), X( :Col 32 ) ),
	Bivariate( Y( :Col ), X( :Col 33 ) ),
	Bivariate( Y( :Col ), X( :Col 34 ) ),
	Bivariate( Y( :Col ), X( :Col 35 ) ),
	Bivariate( Y( :Col ), X( :Col 36 ) ),
	Bivariate( Y( :Col ), X( :Col 37 ) ),
	Bivariate( Y( :Col ), X( :Col 38 ) ),
	Bivariate( Y( :Col ), X( :Col 39 ) ),
	Bivariate( Y( :Col ), X( :Col 40 ) ),
	Bivariate( Y( :Col ), X( :Col 41 ) ),
	Bivariate( Y( :Col ), X( :Col 42 ) ),
	Bivariate( Y( :Col ), X( :Col 43 ) ),
	Bivariate( Y( :Col ), X( :Col 44 ) ),
	Bivariate( Y( :Col ), X( :Col 45 ) ),
	Bivariate( Y( :Col ), X( :Col 46 ) ),
	Bivariate( Y( :Col ), X( :Col 47 ) ),
	Bivariate( Y( :Col ), X( :Col 48 ) ),
	Bivariate( Y( :Col ), X( :Col 49 ) ),
	Bivariate( Y( :Col ), X( :Col 50 ) ),
	Bivariate( Y( :Col ), X( :Col 51 ) ),
	Bivariate( Y( :Col ), X( :Col 52 ) ),
	Bivariate( Y( :Col ), X( :Col 53 ) ),
	Bivariate( Y( :Col ), X( :Col 54 ) ),
	Bivariate( Y( :Col ), X( :Col 55 ) ),
	Bivariate( Y( :Col ), X( :Col 56 ) ),
	Bivariate( Y( :Col ), X( :Col 57 ) ),
	Bivariate( Y( :Col ), X( :Col 58 ) ),
	Bivariate( Y( :Col ), X( :Col 59 ) ),
	Bivariate( Y( :Col ), X( :Col 60 ) ),
	Bivariate( Y( :Col ), X( :Col 61 ) ),
	Bivariate( Y( :Col ), X( :Col 62 ) ),
	Bivariate( Y( :Col ), X( :Col 63 ) ),
	Bivariate( Y( :Col ), X( :Col 64 ) ),
	Bivariate( Y( :Col ), X( :Col 65 ) ),
	Bivariate( Y( :Col ), X( :Col 66 ) ),
	Bivariate( Y( :Col ), X( :Col 67 ) ),
	Bivariate( Y( :Col ), X( :Col 68 ) ),
	Bivariate( Y( :Col ), X( :Col 69 ) ),
	Bivariate( Y( :Col ), X( :Col 70 ) ),
	Bivariate( Y( :Col ), X( :Col 71 ) ),
	Bivariate( Y( :Col ), X( :Col 72 ) ),
	Bivariate( Y( :Col ), X( :Col 73 ) ),
	Bivariate( Y( :Col ), X( :Col 74 ) ),
	Bivariate( Y( :Col ), X( :Col 75 ) ),
	Bivariate( Y( :Col ), X( :Col 76 ) ),
	Bivariate( Y( :Col ), X( :Col 77 ) ),
	Bivariate( Y( :Col ), X( :Col 78 ) ),
	Bivariate( Y( :Col ), X( :Col 79 ) ),
	Bivariate( Y( :Col ), X( :Col 80 ) ),
	Bivariate( Y( :Col ), X( :Col 81 ) ),
	Bivariate( Y( :Col ), X( :Col 82 ) ),
	Bivariate( Y( :Col ), X( :Col 83 ) ),
	Bivariate( Y( :Col ), X( :Col 84 ) ),
	Bivariate( Y( :Col ), X( :Col 85 ) ),
	Bivariate( Y( :Col ), X( :Col 86 ) ),
	Bivariate( Y( :Col ), X( :Col 87 ) ),
	Bivariate( Y( :Col ), X( :Col 88 ) ),
	Bivariate( Y( :Col ), X( :Col 89 ) ),
	Bivariate( Y( :Col ), X( :Col 90 ) ),
	Bivariate( Y( :Col ), X( :Col 91 ) ),
	Bivariate( Y( :Col ), X( :Col 92 ) ),
	Bivariate( Y( :Col ), X( :Col 93 ) ),
	Bivariate( Y( :Col ), X( :Col 94 ) ),
	Bivariate( Y( :Col ), X( :Col 95 ) ),
	Bivariate( Y( :Col ), X( :Col 96 ) ),
	Bivariate( Y( :Col ), X( :Col 97 ) ),
	Bivariate( Y( :Col ), X( :Col 98 ) ),
	Bivariate( Y( :Col ), X( :Col 99 ) ),
	Bivariate( Y( :Col ), X( :Col 100 ) ),
	<<{Arrange in Rows( 3 )}
);
心若止水
aliegner1
Level IV

Re: make all Bivariate plots into a column, rather than a row?

how to make this dynamic? I want to plot my output value Y (Etchrate) against a long group of input columns X (grouped cols) and display in a vertical window of graphs instead of a huge scroll left-right window.

txnelson
Super User

Re: make all Bivariate plots into a column, rather than a row?

  1. Which person are you replying to?  The code I provided in my last response
    Names Default To Here( 1 );
    // Open Data Table: semiconductor capability.jmp
    // → Data Table( "semiconductor capability" )
    dtWide = Open( "$SAMPLE_DATA/semiconductor capability.jmp" );
    ERplot = fit group(
    	bivariate( Y( :NPN1 ), X( dtWIDE<<get column group( "Processes" ) ) ),
    	<<{Arrange in Rows( 1 )}
    );

    provides a vertical list of graphs, using a single x column and a variable grouping for the Y columns.

  2. There is also another platform that you may want to look at, Response Screening.  If you put in your X variable and Y grouping, it will generate a data table with all of the results listed in significance order.  You can then select from the list, and it will display the selected graphs in a vertical list.                     txnelson_0-1645805119971.png

     

Jim