<?xml version="1.0" encoding="UTF-8"?>
<rss xmlns:content="http://purl.org/rss/1.0/modules/content/" xmlns:dc="http://purl.org/dc/elements/1.1/" xmlns:rdf="http://www.w3.org/1999/02/22-rdf-syntax-ns#" xmlns:taxo="http://purl.org/rss/1.0/modules/taxonomy/" version="2.0">
  <channel>
    <title>topic JMP script: Script Alarm Control chart- Table with atypical batch number and values in Discussions</title>
    <link>https://community.jmp.com/t5/Discussions/JMP-script-Script-Alarm-Control-chart-Table-with-atypical-batch/m-p/483077#M72736</link>
    <description>&lt;P&gt;Hello everyone,&lt;/P&gt;&lt;P&gt;I am trying to make a table with the OOT (out of Trend) batches with their respective "atypical" values.&lt;/P&gt;&lt;P&gt;I used for that the "script alarm" function as I could found some exemples on the JMP community.&lt;/P&gt;&lt;P&gt;&amp;nbsp;&lt;/P&gt;&lt;P&gt;Here is my script:&lt;/P&gt;&lt;P&gt;&amp;nbsp;&lt;/P&gt;&lt;PRE&gt;&lt;CODE class=" language-jsl"&gt;	z_KSigmaZ =1.4;

// Création de la Carte de controle si N catégories &amp;gt; 5
	Names Default To Here( 1 );
	If(N Items(Associative Array(:"RNS/NS tordu (srg)")) &amp;gt; 5,
	Graph_expr1=Expr(
		Graph1 = Control Chart(
				Sample Label( :Numéro de lot ),
				Sample Size( :Nombre de seringues ),
				KSigma(TBD),
				Sort by Row Order( 1 ),
			Chart Col( :"RNS/NS tordu (srg)"n, P( Test Beyond Limits( 1 ), Limits Precision( 1 ), LCL( -3 ) ) ),
		Alarm Script(
							Write(
								"Out of Control for test ",
								qc_test,
								" in column ",
								qc_col,
								" in sample ",
								qc_sample,
								"\!N"
							)),
		SendToReport(
		Dispatch(
			{},
			"P of RNS/NS tordu (srg)",
			OutlineBox,
			{Set Title( "p'-chart, Proportion de défaut" )}
		),
		Dispatch(
			{"P of RNS/NS tordu (srg)"},
			"2",
			ScaleBox,
			{Format( "Fixed Dec", 12, 5 ), Min( -0.00025 ), Max( 0.0025 ),
			Inc( 0.00025 ), Minor Ticks( 1 )}
		),
		Dispatch(
			{"P of RNS/NS tordu (srg)"},
			"1",
			ScaleBox,
			{Min( 0.5 ), Inc( 1 ), Minor Ticks( 0 )}
		),
		Dispatch(
			{"P of RNS/NS tordu (srg)"},
			"",
			AxisBox,
			{Add Axis Label( "Taux de défauts (srg)" )}
		))));
	SubstituteInto(Graph_expr1, Expr(TBD), z_KSigmaZ);
	Graph_expr1&amp;lt;&amp;lt; Test 1(1));&lt;/CODE&gt;&lt;/PRE&gt;&lt;P&gt;At the end, I would like to get the batch number, and the atypical value in a table.&lt;/P&gt;&lt;P&gt;&amp;nbsp;&lt;/P&gt;&lt;P&gt;I guess I need to call this function&amp;nbsp;&amp;nbsp;&lt;CODE class=" language-jsl"&gt;Graph_expr1&amp;lt;&amp;lt; Test 1(1)&lt;/CODE&gt;to get the row number, but does not work.&lt;/P&gt;&lt;P&gt;Any suggestion to help me?&lt;/P&gt;&lt;P&gt;&amp;nbsp;&lt;/P&gt;&lt;P&gt;Thanks a lot for your answer,&lt;/P&gt;&lt;P&gt;&amp;nbsp;&lt;/P&gt;&lt;P&gt;&amp;nbsp;&lt;/P&gt;</description>
    <pubDate>Fri, 09 Jun 2023 16:58:02 GMT</pubDate>
    <dc:creator>Sebastienlg</dc:creator>
    <dc:date>2023-06-09T16:58:02Z</dc:date>
    <item>
      <title>JMP script: Script Alarm Control chart- Table with atypical batch number and values</title>
      <link>https://community.jmp.com/t5/Discussions/JMP-script-Script-Alarm-Control-chart-Table-with-atypical-batch/m-p/483077#M72736</link>
      <description>&lt;P&gt;Hello everyone,&lt;/P&gt;&lt;P&gt;I am trying to make a table with the OOT (out of Trend) batches with their respective "atypical" values.&lt;/P&gt;&lt;P&gt;I used for that the "script alarm" function as I could found some exemples on the JMP community.&lt;/P&gt;&lt;P&gt;&amp;nbsp;&lt;/P&gt;&lt;P&gt;Here is my script:&lt;/P&gt;&lt;P&gt;&amp;nbsp;&lt;/P&gt;&lt;PRE&gt;&lt;CODE class=" language-jsl"&gt;	z_KSigmaZ =1.4;

// Création de la Carte de controle si N catégories &amp;gt; 5
	Names Default To Here( 1 );
	If(N Items(Associative Array(:"RNS/NS tordu (srg)")) &amp;gt; 5,
	Graph_expr1=Expr(
		Graph1 = Control Chart(
				Sample Label( :Numéro de lot ),
				Sample Size( :Nombre de seringues ),
				KSigma(TBD),
				Sort by Row Order( 1 ),
			Chart Col( :"RNS/NS tordu (srg)"n, P( Test Beyond Limits( 1 ), Limits Precision( 1 ), LCL( -3 ) ) ),
		Alarm Script(
							Write(
								"Out of Control for test ",
								qc_test,
								" in column ",
								qc_col,
								" in sample ",
								qc_sample,
								"\!N"
							)),
		SendToReport(
		Dispatch(
			{},
			"P of RNS/NS tordu (srg)",
			OutlineBox,
			{Set Title( "p'-chart, Proportion de défaut" )}
		),
		Dispatch(
			{"P of RNS/NS tordu (srg)"},
			"2",
			ScaleBox,
			{Format( "Fixed Dec", 12, 5 ), Min( -0.00025 ), Max( 0.0025 ),
			Inc( 0.00025 ), Minor Ticks( 1 )}
		),
		Dispatch(
			{"P of RNS/NS tordu (srg)"},
			"1",
			ScaleBox,
			{Min( 0.5 ), Inc( 1 ), Minor Ticks( 0 )}
		),
		Dispatch(
			{"P of RNS/NS tordu (srg)"},
			"",
			AxisBox,
			{Add Axis Label( "Taux de défauts (srg)" )}
		))));
	SubstituteInto(Graph_expr1, Expr(TBD), z_KSigmaZ);
	Graph_expr1&amp;lt;&amp;lt; Test 1(1));&lt;/CODE&gt;&lt;/PRE&gt;&lt;P&gt;At the end, I would like to get the batch number, and the atypical value in a table.&lt;/P&gt;&lt;P&gt;&amp;nbsp;&lt;/P&gt;&lt;P&gt;I guess I need to call this function&amp;nbsp;&amp;nbsp;&lt;CODE class=" language-jsl"&gt;Graph_expr1&amp;lt;&amp;lt; Test 1(1)&lt;/CODE&gt;to get the row number, but does not work.&lt;/P&gt;&lt;P&gt;Any suggestion to help me?&lt;/P&gt;&lt;P&gt;&amp;nbsp;&lt;/P&gt;&lt;P&gt;Thanks a lot for your answer,&lt;/P&gt;&lt;P&gt;&amp;nbsp;&lt;/P&gt;&lt;P&gt;&amp;nbsp;&lt;/P&gt;</description>
      <pubDate>Fri, 09 Jun 2023 16:58:02 GMT</pubDate>
      <guid>https://community.jmp.com/t5/Discussions/JMP-script-Script-Alarm-Control-chart-Table-with-atypical-batch/m-p/483077#M72736</guid>
      <dc:creator>Sebastienlg</dc:creator>
      <dc:date>2023-06-09T16:58:02Z</dc:date>
    </item>
  </channel>
</rss>

