Dynamic chart creator

Question

Hi,

I would like to write a script that helps the user to create some required charts with less mouse clicks.

For example, typically when I'm making charts manually, I have to first create X-Y graph, then select legend, then click on Automatic recalc, Unselected faded, group by, and put splines. This turns out to be very tedious.

So basically what I want to write is a script that the user would only have to select Y columns, X columns, Legend column and Group By column. And the script would do the rest.

Clarification: Obviously I know how to script this for a given data table, where I know the columns names and the charts I want to create. What I want here is to enable the user to select the columns he wants in ANY given data table he is working on. I suppose the solution would require loops and variables.

I hope I explained myself clearly.

Any help and guidance would be appreciated.

Thanks!

Yotam · Answer

Turns out I was using JMP12, where the Automatic recalc option was not available in the preferences.

I switched to JMP14 and now I see it.

Thanks!

txnelson · Answer

The Automatic Recalc preference is available for both the Bivariate and Variability Chart

The ability to Fit a Spline is there, but it does not have the "Standardize" checkbox surfaced in the Preferences.

Yotam · Answer

Thanks!

I guess it could also be a solution. The question is whether I can pre define there everything I need.

So a follow up question - Where can I define the following:

1. Automatic recalc for X-Y plot & variability chart?

2. When I do fit spline -> other, is there a way that the Standardize X box would be checked by default?

I looked it up but couldn't find it.

Thanks

Bivariate(
	Y( :y_column),
	X( :x_column ),
	group by(:group_column),
	Automatic Recalc( 1 ),
	Fit spline (0.1, Standardized, {Report(0)}),
	SendToReport(
		Dispatch(
			{},
			"Bivar Plot",
			FrameBox,
			{Marker Selection Mode( "Unselected Faded" ),
			Row Legend(
				legend_column,
				Color( 1 ),
				Color Theme( "JMP Default" ),
				Marker( 0 ),
				Marker Theme( "" ),
				Continuous Scale( 0 ),
				Reverse Scale( 0 ),
				Excluded Rows( 0 )
			)}
		)
	)
)