Choose Language Hide Translation Bar
Highlighted
Hamal22
Level I

Tabulate configuration support

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

3 REPLIES 3
Highlighted
txnelson
Super User

Re: Tabulate configuration support

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 ) ) )
		)
	)
);
Jim
Highlighted
Hamal22
Level I

Re: Tabulate configuration support

thanks for the support, it works.

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

Highlighted
txnelson
Super User

Re: Tabulate configuration support

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.

Jim
Article Labels

    There are no labels assigned to this post.