I want to take a list of dates from one table and use them as reference lines in an X by Y with Date as the X axis.
The date formats are in this format from a table: 12/18/2023 14:14. I would also like to add the label to each line from the same table. In this case it is EPOXI MT25700-02
The script for the chart shows what I would like be able to add from a table to the chart as reference lines. I would like to take the list of dates and lot numbers from a separate table and make them reference lines in a chart.
Bivariate(
Y( :Value ),
X( :CreatedDateTime ),
Where(
:ValueName == "Dispense Weight Chec" & :Site == "SAN" & :ProcessName ==
"CLOUE Unload Station" & :EQNumber == "EQ-902280-001"
),
SendToReport(
Dispatch(
{},
"CreatedDateTime",
ScaleBox,
{Add Ref Line( 3785753640, "Solid", "Black", "EPOXI MT25700-02", 1 )}
),
Dispatch( {}, "Bivar Plot", FrameBox, {Frame Size( 910, 194 )} )
)
)
