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.

fionaweston — Fri, 09 Jun 2023 19:45:31 GMT

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

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.

ms — Tue, 27 Apr 2021 18:29:32 GMT

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(...)

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.

fionaweston — Tue, 27 Apr 2021 19:29:36 GMT

Thanks, that works

topic 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. in Discussions

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.

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.

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.