cancel
Showing results for 
Show  only  | Search instead for 
Did you mean: 
  • Learn how to build custom Python data connectors and further customize JMP’s Data Connector Framework with the Python Data Connector Demo, available now in the JMP Marketplace!
  • See how to create experiments to support product design and ID useful product features. Register for June 12 webinar, 2pm US Eastern Time.

Discussions

Solve problems, and share tips and tricks with other JMP users.
%3CLINGO-SUB%20id%3D%22lingo-sub-710950%22%20slang%3D%22en-US%22%20mode%3D%22NONE%22%3E%E5%9B%9E%E8%A6%86%EF%BC%9A%E5%B0%87%E6%97%A5%E6%9C%9F%E8%BD%89%E6%8F%9B%E7%82%BA%E7%94%A8%E6%96%BC%E5%9C%96%E8%A1%A8%E5%8F%83%E8%80%83%E7%B7%9A%E7%9A%84%E6%A0%BC%E5%BC%8F%3C%2FLINGO-SUB%3E%3CLINGO-BODY%20id%3D%22lingo-body-710950%22%20slang%3D%22en-US%22%20mode%3D%22NONE%22%3E%3CP%3E%E5%A6%82%E6%9E%9C%E9%80%99%E6%98%AF%E6%82%A8%E6%83%B3%E8%A6%81%E7%9A%84%E5%9C%96%E8%A1%A8%E5%BD%A2%E5%BC%8F%3C%2FP%3E%0A%3CP%3E%3CSPAN%20class%3D%22lia-inline-image-display-wrapper%20lia-image-align-inline%22%20image-alt%3D%22txnelson_0-1703043603811.png%22%20style%3D%22width%3A%20400px%3B%22%3E%3CSPAN%20class%3D%22lia-inline-image-display-wrapper%22%20image-alt%3D%22txnelson_0-1703043603811.png%22%20style%3D%22width%3A%20400px%3B%22%3E%3CSPAN%20class%3D%22lia-inline-image-display-wrapper%22%20image-alt%3D%22txnelson_0-1703043603811.png%22%20style%3D%22width%3A%20400px%3B%22%3E%3CSPAN%20class%3D%22lia-inline-image-display-wrapper%22%20image-alt%3D%22txnelson_0-1703043603811.png%22%20style%3D%22width%3A%20400px%3B%22%3E%3CSPAN%20class%3D%22lia-inline-image-display-wrapper%22%20image-alt%3D%22txnelson_0-1703043603811.png%22%20style%3D%22width%3A%20400px%3B%22%3E%3CSPAN%20class%3D%22lia-inline-image-display-wrapper%22%20image-alt%3D%22txnelson_0-1703043603811.png%22%20style%3D%22width%3A%20400px%3B%22%3E%3Cspan%20class%3D%22lia-inline-image-display-wrapper%22%20image-alt%3D%22txnelson_0-1703043603811.png%22%20style%3D%22width%3A%20400px%3B%22%3E%3Cimg%20src%3D%22https%3A%2F%2Fcommunity.jmp.com%2Ft5%2Fimage%2Fserverpage%2Fimage-id%2F59909i6B5C2CE5D7976E32%2Fimage-size%2Fmedium%3Fv%3Dv2%26amp%3Bpx%3D400%22%20role%3D%22button%22%20title%3D%22txnelson_0-1703043603811.png%22%20alt%3D%22txnelson_0-1703043603811.png%22%20%2F%3E%3C%2Fspan%3E%3C%2FSPAN%3E%3C%2FSPAN%3E%3C%2FSPAN%3E%3C%2FSPAN%3E%3C%2FSPAN%3E%3C%2FSPAN%3E%3C%2FP%3E%0A%3CP%3E%E9%80%99%E6%98%AF%E7%94%9F%E6%88%90%E4%B8%8A%E5%9C%96%E7%9A%84%20JSL%3C%2FP%3E%0A%3CPRE%3E%3CCODE%20class%3D%22%20language-jsl%22%3ENames%20Default%20To%20Here(%201%20)%3B%0AData%20Table(%20%22Weight%20Checks%20for%20JP%22%20)%20%26lt%3B%26lt%3B%20Bivariate(%0A%20Y(%20%3AValue%20)%2C%0A%20X(%20%3ACreatedDateTime%20)%2C%0A%20Where(%0A%20%20%3AValueName%20%3D%3D%20%22Dispense%20Weight%20Chec%22%20%26amp%3B%20%3ASite%20%3D%3D%20%22SAN%22%20%26amp%3B%20%3AProcessName%20%3D%3D%0A%20%20%22CLOUE%20Unload%20Station%22%20%26amp%3B%20%3AEQNumber%20%3D%3D%20%22EQ-902280-001%22%0A%20)%2C%0A%20SendToReport(%0A%20%20Dispatch(%0A%20%20%20%7B%7D%2C%0A%20%20%20%22CreatedDateTime%22%2C%0A%20%20%20ScaleBox%2C%0A%20%20%20%7BLabel%20Row(%20Label%20Orientation(%20%22Angled%22%20)%20)%7D%0A%20%20)%2C%0A%20%20Dispatch(%20%7B%7D%2C%20%22Bivar%20Plot%22%2C%20FrameBox%2C%20%7BFrame%20Size(%20910%2C%20194%20)%7D%20)%0A%20)%0A)%3B%0ABivR%20%3D%20Current%20Report()%5BOutline%20Box(%201%20)%2C%20AxisBox(%202%20)%5D%3B%0AFor(%20i%20%3D%201%2C%20i%20%26lt%3B%3D%20N%20Rows(%20Data%20Table(%20%22Bottle%20Change%20Data%22%20)%20)%2C%20i%2B%2B%2C%0A%20BivR%20%26lt%3B%26lt%3B%20Add%20Ref%20Line(%0A%20%20Informat(%20Data%20Table(%20%22Bottle%20Change%20Data%22%20)%3ADate_Time%5Bi%5D%2C%20%22m%2Fd%2Fy%20h%3Am%22%20)%2C%0A%20%20%22Solid%22%2C%0A%20%20%22Black%22%2C%0A%20%20Data%20Table(%20%22Bottle%20Change%20Data%22%20)%3ADescription%5Bi%5D%20%7C%7C%20%22%20%20%22%20%7C%7C%0A%20%20Data%20Table(%20%22Bottle%20Change%20Data%22%20)%3APart_Number%5Bi%5D%2C%0A%20%201%0A%20)%0A)%3B%0A%3C%2FCODE%3E%3C%2FPRE%3E%0A%3CP%3E%E9%80%B2%E5%85%A5%20JSL%20%E6%99%82%EF%BC%8C%E8%AB%8B%E4%BD%BF%E7%94%A8%E8%A8%8E%E8%AB%96%E8%BC%B8%E5%85%A5%E5%8D%80%E5%9F%9F%E9%A0%82%E9%83%A8%E7%9A%84%20%3CJSL%3E%20%E5%9C%96%E7%A4%BA%E3%80%82%E5%AE%83%E4%BD%BF%E7%A8%8B%E5%BC%8F%E7%A2%BC%E7%9A%84%E9%96%B1%E8%AE%80%E8%AE%8A%E5%BE%97%E6%9B%B4%E5%8A%A0%E5%AE%B9%E6%98%93%3C%2FJSL%3E%3C%2FP%3E%3C%2FLINGO-BODY%3E%3CLINGO-SUB%20id%3D%22lingo-sub-710854%22%20slang%3D%22en-US%22%20mode%3D%22NONE%22%3E%E5%B0%87%E6%97%A5%E6%9C%9F%E8%BD%89%E6%8F%9B%E7%82%BA%E7%94%A8%E6%96%BC%E5%9C%96%E8%A1%A8%E5%8F%83%E8%80%83%E7%B7%9A%E7%9A%84%E6%A0%BC%E5%BC%8F%3C%2FLINGO-SUB%3E%3CLINGO-BODY%20id%3D%22lingo-body-710854%22%20slang%3D%22en-US%22%20mode%3D%22NONE%22%3E%3CP%3E%E6%88%91%E6%83%B3%E5%BE%9E%E4%B8%80%E5%80%8B%E8%A1%A8%E4%B8%AD%E7%8D%B2%E5%8F%96%E6%97%A5%E6%9C%9F%E5%88%97%E8%A1%A8%EF%BC%8C%E4%B8%A6%E5%B0%87%E5%AE%83%E5%80%91%E7%94%A8%E4%BD%9C%20X%20x%20Y%20%E4%B8%AD%E7%9A%84%E5%8F%83%E8%80%83%E7%B7%9A%EF%BC%8C%E4%BB%A5%E6%97%A5%E6%9C%9F%E4%BD%9C%E7%82%BA%20X%20%E8%BB%B8%E3%80%82%26nbsp%3B%20%26nbsp%3B%3C%2FP%3E%0A%3CP%3E%E6%97%A5%E6%9C%9F%E6%A0%BC%E5%BC%8F%E6%8E%A1%E7%94%A8%E8%A1%A8%E4%B8%AD%E7%9A%84%E6%A0%BC%E5%BC%8F%EF%BC%9A12%2F18%2F2023%2014%3A14%E3%80%82%E6%88%91%E9%82%84%E6%83%B3%E5%B0%87%E6%A8%99%E7%B1%A4%E6%96%B0%E5%A2%9E%E5%88%B0%E5%90%8C%E4%B8%80%E5%80%8B%E8%A1%A8%E4%B8%AD%E7%9A%84%E6%AF%8F%E4%B8%80%E8%A1%8C%E3%80%82%E6%9C%AC%E4%BE%8B%E7%82%BA%20EPOXI%20MT25700-02%3C%2FP%3E%0A%3CDIV%3E%26nbsp%3B%3C%2FDIV%3E%0A%3CP%3E%26nbsp%3B%3C%2FP%3E%0A%3CP%3E%E5%9C%96%E8%A1%A8%E7%9A%84%E8%85%B3%E6%9C%AC%E9%A1%AF%E7%A4%BA%E4%BA%86%E6%88%91%E5%B8%8C%E6%9C%9B%E8%83%BD%E5%A4%A0%E5%BE%9E%E8%A1%A8%E4%B8%AD%E6%B7%BB%E5%8A%A0%E5%88%B0%E5%9C%96%E8%A1%A8%E4%B8%AD%E4%BD%9C%E7%82%BA%E5%8F%83%E8%80%83%E7%B7%9A%E7%9A%84%E5%85%A7%E5%AE%B9%E3%80%82%E6%88%91%E6%83%B3%E5%BE%9E%E5%96%AE%E7%8D%A8%E7%9A%84%E8%A1%A8%E4%B8%AD%E7%8D%B2%E5%8F%96%E6%97%A5%E6%9C%9F%E5%92%8C%E6%89%B9%E8%99%9F%E5%88%97%E8%A1%A8%EF%BC%8C%E4%B8%A6%E5%B0%87%E5%AE%83%E5%80%91%E4%BD%9C%E7%82%BA%E5%9C%96%E8%A1%A8%E4%B8%AD%E7%9A%84%E5%8F%83%E8%80%83%E7%B7%9A%E3%80%82%3C%2FP%3E%0A%3CP%3E%26nbsp%3B%3C%2FP%3E%0A%3CP%3E%26nbsp%3B%3C%2FP%3E%0A%3CDIV%3E%0A%3CPRE%3E%3CCODE%20class%3D%22%20language-jsl%22%3EBivariate(%0A%20Y(%3AValue)%2C%0A%20X(%3ACreatedDateTime)%2C%0A%20Where(%0A%20%20%3AValueName%20%3D%3D%20%22Dispense%20Weight%20Chec%22%20%26amp%3B%20%3ASite%20%3D%3D%20%22SAN%22%20%26amp%3B%20%3AProcessName%20%3D%3D%0A%20%20%22CLOUE%20Unload%20Station%22%20%26amp%3B%20%3AEQNumber%20%3D%3D%20%22EQ-902280-001%22%0A%20)%2C%0A%20SendToReport(%0A%20%20Dispatch(%0A%20%20%20%7B%7D%2C%0A%20%20%20%22CreatedDateTime%22%2C%0A%20%20%20ScaleBox%2C%0A%20%20%20%7BAdd%20Ref%20Line(3785753640%2C%20%22Solid%22%2C%20%22Black%22%2C%20%22EPOXI%20MT25700-02%22%2C%201)%7D%0A%20%20)%2C%0A%20%20Dispatch(%7B%7D%2C%20%22Bivar%20Plot%22%2C%20FrameBox%2C%20%7BFrame%20Size(910%2C%20194)%7D)%0A%20)%0A)%3C%2FCODE%3E%3C%2FPRE%3E%0A%3C%2FDIV%3E%3C%2FLINGO-BODY%3E%3CLINGO-LABS%20id%3D%22lingo-labs-710854%22%20slang%3D%22en-US%22%20mode%3D%22NONE%22%3E%3CLINGO-LABEL%3E%E5%88%86%E4%BA%AB%E5%92%8C%E4%BA%A4%E6%B5%81%E6%88%90%E6%9E%9C%3C%2FLINGO-LABEL%3E%3C%2FLINGO-LABS%3E
Choose Language Hide Translation Bar
cjackso21
Level I

Convert Date to a format used for chart reference lines

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)})
	)
)
1 REPLY 1
txnelson
Super User

Re: Convert Date to a format used for chart reference lines

If this is the form of the graph that you want

txnelson_0-1703043603811.png

Here is the JSL that produces the above graph

Names Default To Here( 1 );
Data Table( "Weight Checks for JP" ) << Bivariate(
	Y( :Value ),
	X( :CreatedDateTime ),
	Where(
		:ValueName == "Dispense Weight Chec" & :Site == "SAN" & :ProcessName ==
		"CLOUE Unload Station" & :EQNumber == "EQ-902280-001"
	),
	SendToReport(
		Dispatch(
			{},
			"CreatedDateTime",
			ScaleBox,
			{Label Row( Label Orientation( "Angled" ) )}
		),
		Dispatch( {}, "Bivar Plot", FrameBox, {Frame Size( 910, 194 )} )
	)
);
BivR = Current Report()[Outline Box( 1 ), AxisBox( 2 )];
For( i = 1, i <= N Rows( Data Table( "Bottle Change Data" ) ), i++,
	BivR << Add Ref Line(
		Informat( Data Table( "Bottle Change Data" ):Date_Time[i], "m/d/y h:m" ),
		"Solid",
		"Black",
		Data Table( "Bottle Change Data" ):Description[i] || "  " ||
		Data Table( "Bottle Change Data" ):Part_Number[i],
		1
	)
);

Please use the <JSL> icon at the top of the Discussion Entry area when you are entering JSL.  It makes the reading of the code much easier

Jim

Recommended Articles