418264_en-US

liliconcom

How to get the Column Switcher to get all columns in a Data Table to use for a control chart

Hello Everyone, 

 

I am trying to get use the Column Switcher to automatically pull all of the columns in the data table when creating a control chart so I can rotate through all of them at once. I get the control chart to work but not the Column Switcher. I have tried to research it and nothing seems to be working. Any help will be greatly appreciated.

 

Below is the code I have been using:  

 

dt5= Open("filex");

dt5= Data Table( "filex" );
colNamesList = dt5 << get Column names (string, Continuous);

Control Chart Builder(
 Size( 534, 464 ),
 Show Control Panel( 0 ),
 Variables( Y( eval(colNamesList) ) ),
 Chart(
  Position( 1 ),
  Limits( Shade Zones( 1 ) ),
  Warnings(
   Test 1( 1 ),
   Test 2( 1 ),
   Test 3( 1 ),
   Test 4( 1 ),
   Test 5( 1 ),
   Test 6( 1 ),
   Test 7( 1 ),
   Test 8( 1 )
  )),
Column Switcher(colNamesList ));

Thanks,

 

Ryan

ScriptingRe: How to get the Column Switcher to get all columns in a Data Table to use for a control chart

If you run the control chart and set it up the way you want it to have it look, you can then save the script and use it to model what you need to create the script.  Here is the results of doing that for your analysis

Names Default To Here( 1 );
dt5= Open("filex");
colNamesList = dt5 << get Column names( string, Continuous );

Control Chart Builder(
 Size( 534, 464 ),
 Show Control Panel( 0 ),
 Variables( Y( Eval( colNamesList[1] ) ) ),
 Chart(
  Position( 1 ),
  Limits( Shade Zones( 1 ) ),
  Warnings(
   Test 1( 1 ),
   Test 2( 1 ),
   Test 3( 1 ),
   Test 4( 1 ),
   Test 5( 1 ),
   Test 6( 1 ),
   Test 7( 1 ),
   Test 8( 1 )
  )
 ),
 column switcher( colNamesList[1], Eval( colNamesList ) )
);