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

Part of my script makes a subset of my data. At the very end of my script I try to graph of the subset of data.

Everything else runs fine except for I don't get a graph built for my Subset data table. 
And I don't get any error. Any ideas what is wrong?

Thanks

First part is making the subset
Second is calling the subset to make the graph

//MAKE CANCELLED INTO SUBSET // New column: Column 1 Data Table( "Work Order Log" ) << New Column( "Column 1", Numeric, "Continuous", Format( "Best", 12 ), Set Selected ) << Move Selected Columns( {:Column 1}, To First ); // Change column formula: Column 1 :Column 1 << Set Formula( If( Contains( Uppercase( :CAUSECODEDESCRIPTION ), "OPENED IN ERROR" ), 1, Contains( Uppercase( :CAUSECODEDESCRIPTION ), "CUSTOMER CANCELLED" ), 1, Contains( Uppercase( :CAUSECODEDESCRIPTION ), "CANCELLED - INCORRECT SYSTEM" ), 1, Contains( Uppercase( :CAUSECODEDESCRIPTION ), "DUPLICATE CALL" ), 1 ) ); // Subset data table // → Data Table( "Subset of Work Order Log" ) Data Table( "Work Order Log" ) << Select Where( :Column 1 == 1 ) << Subset( Selected Rows( 1 ), Selected columns only( 0 ) ); // Delete selected rows Data Table( "Work Order Log" ) << Select Where( :Column 1 == 1 ) << Delete Rows;
Data Table( "Subset of Work Order Log" );
Graph Builder(
	Variables( X( :"Week[OPENTIME]"n ), Overlay( :CAUSECODEDESCRIPTION ) ),
	Elements(
		Bar( X, Legend( 2 ), Bar Style( "Stacked" ), Label( "Label by Value" ) )
	)
);
1 ACCEPTED SOLUTION

Accepted Solutions
ms
Super User (Alumni) ms
Super User (Alumni)

Re: Part of my script makes a subset of my data. At the very end of my script I try to graph of the subset of data.

Maybe the current data table at runtime is not what is assumed. Try using Send instead of Glue in the last part, i.e. << instead of a semicolon. 

 

 

Data Table( "Subset of Work Order Log" ) << Graph Builder(...)

 

View solution in original post

2 REPLIES 2
ms
Super User (Alumni) ms
Super User (Alumni)

Re: Part of my script makes a subset of my data. At the very end of my script I try to graph of the subset of data.

Maybe the current data table at runtime is not what is assumed. Try using Send instead of Glue in the last part, i.e. << instead of a semicolon. 

 

 

Data Table( "Subset of Work Order Log" ) << Graph Builder(...)

 

fionaweston
Level III

Re: Part of my script makes a subset of my data. At the very end of my script I try to graph of the subset of data.

Thanks, that works