Add filter for bivariate plot

Question

Hi

Have a scheduled job with a connected JSL script that plot a bivariate plot for a value (y-axis) with time (X-axis).

I want to add a user interface (like a drop-menu) for this report, which could help the user pick the 'Product', and the plot would update to show the only chosen product..

This way, the report would stay short and easy to comprehend. The user could swipe between different products easily.

Tried using the 'Column Switcher' but It did not work, I guess I did not understand it completely.

Script is attached below:

dt = Current Data Table(); // Assuming the data table is open
dt << New Column("group",Character,Nominal,
	Formula (If( :"SITE@NTSC@Process-1@ETCHER@163096" == "D1D", "D1D",
		If(Left( :"CHAMBER@NTSC@Process-1@ETCHER@163096", 3 ) == "GTX", :"CHAMBER@NTSC@Process-1@ETCHER@163096"))
	));

prods = uniqueValueList = (:"PRODUCT@STARTS");
Show(prods);

New Window( "DEPOP FRAC - Bivariate",
	V List Box(
		Bivariate(
			Y(:Name(
					"SPCRAW@WAFER@MEAN@ONTFE.HM_FRAC_LOT_2PT_DYN.74.DER@ML=2PT_DYN_A;PP=2PT_MEAN@188426"
				)
			),
			X(:Name( "END_TIME@CHAMBER@NTSC@Process-1@ETCHER@163096" ) ),

By( :Name( "PRODUCT@STARTS" ) ),

GroupBy( :group ),
			Fit Spline( 0.1, Standardized, {Line Width( 2 )} ),
			UnGroup;

Fit Where(:group == "D1D",
				Fit Spline(0.1,Standardized,{Line Color( "Black" ), Line Width( 4 )}));

Column Switcher(:"PRODUCT@STARTS",	{ :prods});

SendToReport(
				Dispatch(
					{},
					"Bivar Plot",
					FrameBox,
					{Frame Size( 493, 277 ),
					Row Legend(
						chamber,
						Color( 1 ),
						Color Theme( "JMP Default" ),
						Marker( 0 ),
						Marker Theme( "" ),
						Continuous Scale( 0 ),
						Reverse Scale( 0 ),
						Excluded Rows( 0 )
					)}
				),

)
		))
		);

ian_jmp · Answer

FWIW, this shows how to use 'Column Switcher' (if that's what you need):

NamesDefaultToHere(1);

dt = Open("$SAMPLE_DATA/Semiconductor Capability.jmp");

// Get a list of the parameters that could play the 'Y' role
cols = dt << getColumnNames("String");
RemoveFrom(cols, 1, 4);

// Build a report with the column switcher
ow = dt << Oneway(Y(cols[1]), X(:SITE), Column Switcher(cols[1], cols));

pauldeen · Answer

Your different products are in rows right. Open up a local data filter on your group column to let users only look at certain products.

ZF · Answer

Would a data filter work? Names default to here(1); // Open Data Table: big class.jmp dt=Open( "$SAMPLE_DATA/big class.jmp" );
//bivariate fit and add a local data filter
Biv= dt<