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