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

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

rmthomas — Fri, 09 Jun 2023 19:56:43 GMT

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

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

txnelson — Tue, 14 Sep 2021 19:46:43 GMT

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 ) )
);

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

rmthomas — Tue, 14 Sep 2021 20:33:35 GMT

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