topic Get Y axis column name from the variability chart in Discussions

Get Y axis column name from the variability chart

Jackie_ — Fri, 19 May 2023 02:19:02 GMT

Hi,

Is there a way to get the Y axis column name from the variability? I tried using get Y axis but doesn't work. Any suggestions?

Names Default To Here( 1 );
dt = Open( "$SAMPLE_DATA/Variability Data/2 Factors Crossed.jmp" );
obj = dt << Variability Chart( Y( :Measurement ), X( :Operator, :part# ) );

ax = obj << get y axis;
Show( ax );

chart

Re: Get Y axis column name from the variability chart

txnelson — Fri, 19 May 2023 04:44:34 GMT

Here is one way to get the Y column name

Names Default To Here( 1 );
dt = Open( "$SAMPLE_DATA/Variability Data/2 Factors Crossed.jmp" );
obj = dt << variability chart( Y( :Measurement ), X( :Operator, :part# ) );

// Parse the returned script to find the specified Y column
theYColumn = Word(
	1,
	Substr( Char( obj << get script ), Contains( Char( obj << get script ), "Y(:" ) + 3 ),
	"),"
);

Re: Get Y axis column name from the variability chart

jthi — Fri, 19 May 2023 07:34:33 GMT

Column name is in at least four different places:

Your creation script
Three times in the report
- Variability Gauge Analysis for Measurement
- Variability Chart for Measurement
- And Y-axis

Is there a specific reason to get it from Y-axis which is most likely the most difficult one?

Names Default To Here(1);

dt = Open("$SAMPLE_DATA/Variability Data/2 Factors Crossed.jmp");

var = dt << Variability Chart(Y(:Measurement), X(:Operator, :part#));

yaxis_text = Report(var)["Variability Chart for Measurement", Text Box(1)] << get text;

Re: Get Y axis column name from the variability chart

Jackie_ — Fri, 19 May 2023 13:16:37 GMT

I am trying to create an interactive plot with radio buttons and column switchers. For that I need to get column names in the current Y axis VC to be able to replace columns in the column switcher

Re: Get Y axis column name from the variability chart

Jackie_ — Fri, 19 May 2023 13:17:00 GMT

Thanks Jim and Jarmo!