633044_en-US

liliconcom

Get Y axis column name from the variability chart

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

 

 

Automation and ScriptingRe: Get Y axis column name from the variability chart

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

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

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

Thanks Jim and Jarmo!