cancel
Showing results for 
Show  only  | Search instead for 
Did you mean: 
Submit your abstract to the call for content for Discovery Summit Americas by April 23. Selected abstracts will be presented at Discovery Summit, Oct. 21- 24.
Discovery is online this week, April 16 and 18. Join us for these exciting interactive sessions.
Choose Language Hide Translation Bar
ted_ellefson
Level III

Customize & save preferences in Fit Y by X Mean Std Dev report

Hello,

The JMP17 Fit Y by X, "Means and Std Dev" output report changed the standard columns output.

I know how to change the displayed columns by right-clicking on the table and choosing the Columns I want to see.

I don't know how to make this a permanent preference for when I do this again on other data files.  I checked Preferences but, couldn't find where to change this.  Could someone please advise me on what to do?

I appreciate the additional available columns, but I don't want this output to be my standard.  I've had two other engineers here in my company ask me for help to make this preference change as well.

 

2023-02-21 16_03_37-Popcorn - Fit Y by X of yield by popcorn - JMP.png2023-02-21 16_03_56-Popcorn - Fit Y by X of yield by popcorn - JMP.png

2 ACCEPTED SOLUTIONS

Accepted Solutions

Re: Customize & save preferences in Fit Y by X Mean Std Dev report

 Hi,

There may be a way to save this permanently in preferences, but it is also a good candidate for a custom scripted solution.  Please try the script below and see if it does what you need.  This could then be packaged and distributed as an add-in or a custom menu item.

 

(By the way, it took less than 10 minutes to write this with the help of Workflow Builder.  I saved the Fit-Y-by-X script after setting it up the way I wanted and then simply added the column dialog options at the top).

 

Names Default To Here( 1 );

dt=Current Data Table();

dlg = Column Dialog(
	yCol = Col List( "Y, Data",
		Data Type( Numeric ),
		Min Col(1),
		Max Col(1)
	),
	xCol = Col List( "X, Data",
		Data Type( Character ),
		Min Col(1),
		Max Col(1)
	),
	"Select data for Fit-Y-By-X with Means and Std"
);

If( dlg["Button"] == -1, Throw( "User cancelled" ) );
Remove From( dlg ); Eval List( dlg );


//Report snapshot: DataTable - Fit Y by X of Y by X
dt << Oneway(
	Y( yCol[1] ),
	X( xCol[1] ),
	Means and Std Dev( 1 ),
	Mean Error Bars( 1 ),
	Std Dev Lines( 1 ),
	SendToReport(
		Dispatch(
			{"Means and Std Deviations"},
			"Std Err Mean",
			NumberColBox,
			{Visibility( "Collapse" )}
		),
		Dispatch(
			{"Means and Std Deviations"},
			"Lower 95%",
			NumberColBox,
			{Visibility( "Collapse" )}
		),
		Dispatch(
			{"Means and Std Deviations"},
			"Upper 95%",
			NumberColBox,
			{Visibility( "Collapse" )}
		),
		Dispatch(
			{"Means and Std Deviations"},
			"Std Dev Lower 95%",
			NumberColBox,
			{Visibility( "Collapse" )}
		),
		Dispatch(
			{"Means and Std Deviations"},
			"Std Dev Upper 95%",
			NumberColBox,
			{Visibility( "Collapse" )}
		),
		Dispatch(
			{"Means and Std Deviations"},
			"~Std Dev",
			PlotColBox,
			{Visibility( "Collapse" )}
		)
	)
);

View solution in original post

Re: Customize & save preferences in Fit Y by X Mean Std Dev report

Hey Ted,

 

This is got much easier to do in JMP 17.  Turn on Means and Std Deviations then go to the red triangle the platform preferences (New in JMP 17) and select Save changes to ...   This should work for all future oneway plots for this to pop up automatically.

View solution in original post

4 REPLIES 4

Re: Customize & save preferences in Fit Y by X Mean Std Dev report

 Hi,

There may be a way to save this permanently in preferences, but it is also a good candidate for a custom scripted solution.  Please try the script below and see if it does what you need.  This could then be packaged and distributed as an add-in or a custom menu item.

 

(By the way, it took less than 10 minutes to write this with the help of Workflow Builder.  I saved the Fit-Y-by-X script after setting it up the way I wanted and then simply added the column dialog options at the top).

 

Names Default To Here( 1 );

dt=Current Data Table();

dlg = Column Dialog(
	yCol = Col List( "Y, Data",
		Data Type( Numeric ),
		Min Col(1),
		Max Col(1)
	),
	xCol = Col List( "X, Data",
		Data Type( Character ),
		Min Col(1),
		Max Col(1)
	),
	"Select data for Fit-Y-By-X with Means and Std"
);

If( dlg["Button"] == -1, Throw( "User cancelled" ) );
Remove From( dlg ); Eval List( dlg );


//Report snapshot: DataTable - Fit Y by X of Y by X
dt << Oneway(
	Y( yCol[1] ),
	X( xCol[1] ),
	Means and Std Dev( 1 ),
	Mean Error Bars( 1 ),
	Std Dev Lines( 1 ),
	SendToReport(
		Dispatch(
			{"Means and Std Deviations"},
			"Std Err Mean",
			NumberColBox,
			{Visibility( "Collapse" )}
		),
		Dispatch(
			{"Means and Std Deviations"},
			"Lower 95%",
			NumberColBox,
			{Visibility( "Collapse" )}
		),
		Dispatch(
			{"Means and Std Deviations"},
			"Upper 95%",
			NumberColBox,
			{Visibility( "Collapse" )}
		),
		Dispatch(
			{"Means and Std Deviations"},
			"Std Dev Lower 95%",
			NumberColBox,
			{Visibility( "Collapse" )}
		),
		Dispatch(
			{"Means and Std Deviations"},
			"Std Dev Upper 95%",
			NumberColBox,
			{Visibility( "Collapse" )}
		),
		Dispatch(
			{"Means and Std Deviations"},
			"~Std Dev",
			PlotColBox,
			{Visibility( "Collapse" )}
		)
	)
);
ted_ellefson
Level III

Re: Customize & save preferences in Fit Y by X Mean Std Dev report

Hello HadleyMyers, thank you very much for suggesting this scripting option.  I'll take a look and see if others can use this.

 

Does anyone know of a non-scripting option?  I would prefer a non-scripting option so it is easier to deploy the solution.

Re: Customize & save preferences in Fit Y by X Mean Std Dev report

Hey Ted,

 

This is got much easier to do in JMP 17.  Turn on Means and Std Deviations then go to the red triangle the platform preferences (New in JMP 17) and select Save changes to ...   This should work for all future oneway plots for this to pop up automatically.

ted_ellefson
Level III

Re: Customize & save preferences in Fit Y by X Mean Std Dev report

Thanks Peter for helping.  As we discussed just now on the phone, we were not able to change the Preferences on this table using this method.

I was able to change the Columns in the table, and when I Redo Analysis the same Columns were selected.  But, I was not able to change my Preferences.  I'll add an item to the Wish List to be able to select Columns from the Fit Y by X Means and Std Dev.  Thank you