Hi,
I'm trying to create new score card for our group,
the score card seems to work great, I just wanted to add the option for the user to have only the first grouping columns (:owner), and if he press on a relevant button then the net grouping column will appear (:buckets), is their an option to do it?
also, it seems that the ROUND() function does not work in this setting, any other option?
thanks for the support!
Tabulate(
FP = "mm";
dt_all = Open( FP || "\mm.csv", invisible );
dt_all:supplier_ww << Data Type( Character );
Change Item Label(
Grouping Columns( :buckets( "All" ), "All" ),
Grouping Columns( :supplier_ww( "All" ), "All" ),
Grouping Columns( :main_route( "All" ), "All" ),
Grouping Columns( :test_name( "All" ), "All" ),
Grouping Columns( :supplier_chamber( "All" ), "All" )
);,
Show Control Panel( 0 ),
Order by count of grouping columns( 0 ),
Add Table(
Column Table(
Grouping Columns( :supplier_ww, :chart_type ),
Add Aggregate Statistics( :supplier_ww, :chart_type ),
Statistics( Mean ),
Analysis Columns( Transform Column( "score", Formula(round( (:Total_Good_Chamber / :Total_Wfr_Chamber),2 ) ) ) )
),
Row Table(
Grouping Columns( :owner, :buckets, :main_route, :test_name, :supplier_chamber ),
Add Aggregate Statistics( :owner, :buckets, :main_route, :test_name, :supplier_chamber )
)
),
Local Data Filter(
Conditional,
Add Filter(
columns( :owner, :chart_type, :supplier_ww, :buckets, :main_route, :test_name, :supplier_chamber ),
Display( :owner, Size( 93, 442 ), Check Box Display ),
Display( :chart_type, Size( 98, 82 ), Check Box Display ),
Display( :supplier_ww, Size( 93, 442 ), Check Box Display ),
Display( :buckets, Size( 202, 962 ), Check Box Display ),
Display( :main_route, Size( 110, 1282 ), Check Box Display ),
Display( :test_name, Size( 171, 2582 ), Check Box Display ),
Display( :supplier_chamber, Size( 157, 2822 ), Check Box Display )
)
)
)