cancel
Turn on suggestions
Auto-suggest helps you quickly narrow down your search results by suggesting possible matches as you type.
Showing results for 
Show  only  | Search instead for 
Did you mean: 
Try the Materials Informatics Toolkit, which is designed to easily handle SMILES data. This and other helpful add-ins are available in the JMP® Marketplace
Choose Language Hide Translation Bar
ayuan6
ayuan6
Level I

How do I reference a column value as a reference line on a control chart?

May 14, 2020 11:59 AM (1259 views)

Hi,

 

I'm trying to create a script which generates control charts which plots net yields by WO that references a planned yield entry in the %Planned Yield. Since I'd like to create a chart for each product in my data table, and there is a different planned yield for each product, I need to create a reference to the %Planned Yield Column.

 

I have created a script so that the control chart will generate but the line of code I've created is not creating the reference line. Below is the data table I'm referencing across two products (In total there are 10 products in the data table that the script is generating control charts for). 

 

ayuan6_0-1589471405178.png

I've scripted the following to generate the control chart by 'product'. The control charts are generating, but it's not creating the reference line for planned yield. 

ayuan6_1-1589471527015.png

This is a snap shot of the output vs. what I was looking to create. 

 

ayuan6_2-1589471772791.png

Any advice would be greatly appreciated!

 

 

 

0 Kudos
1 REPLY 1
Mark_Bailey
Staff Mark_Bailey
Staff

Re: How do I reference a column value as a reference line on a control chart?

May 14, 2020 12:33 PM (1256 views)  |  Posted in reply to message from ayuan6 05-14-2020

This issue has been discussed before. The Send To Report argument in the launch is not intended for us. It is a mechanism used by JMP to save customizations. You should instead send the Add Ref Line() message directly to the target axis box object. First, save a reference to the control chart platform object. Then ask the object for the reference to the report layer using the << Report message. Subscript this reference to address the axis box for the message send.

0 Kudos