I have two tables
Table1 is dt=Data Table("Data"); It has columns :WAFER, :STRUCTURE, :PARAMETER and :Value
Table2 is dtr= Data Table("Targets"); it has columns :PARAMETER, USL, LSL & Target
In one window ( that is active and can be used for point selection or changing legends) I want to have variability charts of all the parameters along with reference lines added (Target, USL, LSL) for each PARAMETER
if a parameter does not have a target, in the Targets file (dtr) but has data in the DATA file (dt) , the variability plot is created without the reference lines. Otherwise reference lines are added
nw << Append(
vc = dt << Variability Chart(
Y(:Normalize Value),
X(:STRUCTURE, :WAFER),
Variability Analysis(
:Value,
Connect Cell Means(1),
Std Dev Chart(0),
Points Jittered(1),
AIAG Labels(0),
Show Box Plots(1)
),
Where(:Parameter == currentParam),
SendToReport(
Dispatch({"Variability Chart for Normalize Value"}, "2", ScaleBox,
{Add Ref Line(lsl, "Dotted", "Red", "LSL", 2),
Add Ref Line(target, "Solid", "Black", "Target", 2),
Add Ref Line(usl, "Dotted", "Red", "USL", 2)}
)
)
)
);
Edit (jthi): added jsl formatting