Names Default To Here(1);
dt = Open("$DOWNLOADS/StackX.jmp");
/* create calculation column */
dt << New Column("Ones", Numeric, Continuous, <<SET each="" value=""> 0,
dt_split[missing_vals, col_name] = 0
);
);
/* could try plotting here but we join table back */
dt_joined = dt << Join(
With(dt_split),
Merge Same Name Columns,
Match Flag(0),
By Matching Columns(:LOT_NO = :LOT_NO, :WAFER_ID = :WAFER_ID, :Y_AXIS = :Y_AXIS, :X = :X),
Drop multiples(0, 0),
Include Nonmatches(1, 0),
Preserve main table order(1)
);
Close(dt_split, no save);
Close(dt, no save);
/* exclude rows with missing bins */
dt_joined << Select Where(Is Missing(:Bin)) << Hide and Exclude(1) << Clear Select;
Graph Builder(
Size(673, 716),
Variables(X(:X), Y(:Y_AXIS), Wrap(:LOT_NO), Color(:"1"n, Summary Statistic("Sum"))),
Elements(Heatmap(X, Y, Legend(2), Label("Label by Value"))),
Local Data Filter(Width(181), Add Filter(columns(:WAFER_ID, :LOT_NO), Display(:WAFER_ID, N Items(15)))),
Column Switcher(
:"1"n,
{:"1"n, :"10"n, :"11"n, :"12"n, :"16"n, :"17"n, :"20"n, :"21"n, :"23"n, :"27"n, :"31"n, :"32"n, :"33"n, :"50"n, :"53"n, :"66"n, :"69"n,
:"70"n, :"74"n, :"76"n, :"77"n, :"79"n, :"80"n, :"82"n, :"83"n, :"87"n, :"88"n, :"94"n, :"104"n, :"106"n, :"107"n, :"114"n, :"202"n,
:"245"n}
),
SendToReport(
Dispatch({}, "X", ScaleBox, {Min(0), Max(26), Inc(1), Minor Ticks(0), Label Row(Show Major Grid(1))}),
Dispatch({}, "Y_AXIS", ScaleBox, {Min(23), Max(0), Inc(1), Minor Ticks(0), Label Row(Show Major Grid(1))}),
Dispatch(
{},
"400",
ScaleBox,
{Legend Model(
2,
Properties(-1, {gradient({Color Theme("Green Yellow Red"), Reverse Gradient(1), Width(12)})}, Item ID("Count", 1))
)}
),
Dispatch({}, "Graph Builder", FrameBox, {Background Color(32)})
)
);</SET>
