cancel
Showing results for 
Show  only  | Search instead for 
Did you mean: 
Choose Language Hide Translation Bar
rmthomas
Level III

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

1 ACCEPTED SOLUTION

Accepted Solutions
txnelson
Super User

Re: 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 ) )
);
Jim

View solution in original post

2 REPLIES 2
txnelson
Super User

Re: 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 ) )
);
Jim
rmthomas
Level III

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

 Thank you @txnelson  for your help it worked exactly how I needed it to.