topic Re: Tabulate configuration support in Discussions

Tabulate configuration support

Hamal22 — Mon, 11 May 2020 10:36:13 GMT

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

Re: Tabulate configuration support

txnelson — Mon, 11 May 2020 14:19:06 GMT

There is not an option to do directly what you are asking to do, however, by using a little JSL, I think you can get done what you want. Below is a simple example that should allow you go move towards your solution. It allows the user to push a button on a Tablulate, to force a display change

Names Default To Here( 1 );
dt = Open( "$SAMPLE_DATA/big class.jmp" );


nw = New Window( "Tabulate",
	hlb = H List Box(
		bb = Button Box( "Push to See Ages",
			If( bb << get button name == "Push to See Ages",
				tab << delete;
				hlb << append(
					tab = Tabulate(
						Show Control Panel( 0 ),
						Add Table(
							Column Table( Analysis Columns( :height ) ),
							Row Table( Grouping Columns( :sex, :age ) )
						)
					)
				);
				bb << set button name( "Push to Remove Ages" );
			,
				tab << delete;
				hlb << append(
					tab = Tabulate(
						Show Control Panel( 0 ),
						Add Table(
							Column Table( Analysis Columns( :height ) ),
							Row Table( Grouping Columns( :sex ) )
						)
					)
				);
				bb << set button name( "Push to See Ages" );
			)
		),
		tab = Tabulate(
			Show Control Panel( 0 ),
			Add Table( Column Table( Analysis Columns( :height ) ), Row Table( Grouping Columns( :sex ) ) )
		)
	)
);

Re: Tabulate configuration support

Hamal22 — Tue, 12 May 2020 10:21:32 GMT

thanks for the support, it works.

can you please advice on a way to color the result per specific values?

Re: Tabulate configuration support

txnelson — Tue, 12 May 2020 11:21:12 GMT

I am assuming that you want to color certain cells within the output from the Tablulate Platform. Tabulate does not have coloring capabilities. To handle this, you would have to do something like "<< make into data table", to create a data table and then color the cells in the data table.