cancel
Showing results for 
Show  only  | Search instead for 
Did you mean: 
Try the Materials Informatics Toolkit, which is designed to easily handle SMILES data. This and other helpful add-ins are available in the JMP® Marketplace
Choose Language Hide Translation Bar
mostarr
Level IV

Creating a dynamically linked table

Hi, I created a set of tables from a script using the Tabulate feature, but they don't appear to be dynamically linked. Is there a way to amend this, or how else would one go about creating a dynamically linked table in JMP / JSL?

 

FYI by dynamically linked I mean, when you click on a cell in the table, it selects the corresponding data samples.

 

Mike

4 REPLIES 4
jthi
Super User

Re: Creating a dynamically linked table

Tabulate should be linked to data table. Subset and Summary do offer Link To Original Data Table option.

-Jarmo
mostarr
Level IV

Re: Creating a dynamically linked table

Hi @jthi. My code, with confidential data removed, is something like this (maybe posting it up will help):

Contingency(
	SendToByGroup( {:Name( "A or B" ) == "A"} ),
	Y( :Name( "Result x" ) ),
	SendToByGroup(
		{:Name( "A or B" ) == "A"},
		Y( :Name( "Result x" ) )
	),
	SendToByGroup(
		{:Name( "A or B" ) == "B"},
		Y( :Name( "Result x" ) )
	),
	X( :Name( "Result y" ) ),
	Automatic Recalc( 1 ),
	Contingency Table( Total %( 0 ), Col %( 0 ), Row %( 0 ) ),
	Mosaic Plot( 0 ),
	Tests( 0 ),
	By( :Name( "A or B" ) ),
	SendToByGroup(
		{:Name( "A or B" ) == "A"},
		Local Data Filter(
			Add Filter(
				columns(
					:Target,
					:Name( "Data x" )
				),
				Where( :Target == "background" ),
				Where(
					:Name( "Data x" ) == "True"
				),
				Display( :Target, Size( 160, 60 ), List Display )
			)
		)
	),
	SendToByGroup(
		{:Name( "A or B" ) == "B"},
		Local Data Filter(
			Add Filter(
				columns(
					:Target,
					:Name( "Data x" )
				),
				Where( :Target Channel == "background" ),
				Where(
					:Name( "Data x" ) == "True"
				),
				Display( :Target, Size( 160, 60 ), List Display )
			)
		)
	)
);

So I am using the Contingency Table feature. Does that allow for dynamic linking, and if not, what would be the best workaround?

txnelson
Super User

Re: Creating a dynamically linked table

Just to clarify @jthi statement.

Tabulate is not linked the data table, but should be linked. Subset and Summary do offer Link To Original Data Table option.

 

 

Many of the Tabulate features can be created using the Group and SubGroup capability in Summary, 

 

See Ledi's response below

Jim
ledi_trutna
Level IV

Re: Creating a dynamically linked table

In Tabulate, you need to click on the specific count or other statistic in the resulting cells zone to get the rows selected in the data table. If you click on whatever goes in the drop zones for rows, it will not select rows. 

Tables > Summary will by default create a linked summary table which I use all the time for selecting rows in a larger table.