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 )
)}
),
)
))
);
Would a data filter work?
Names default to here(1);
// Open Data Table: big class.jmp
dt=Open( "$SAMPLE_DATA/big class.jmp" );
<BR />//bivariate fit and add a local data filter
<BR />Biv= dt<<BIVARIATE></BIVARIATE>
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.