Creating a dynamically linked table

Question

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

txnelson · Answer

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

ledi_trutna · Answer

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.

mostarr · Answer

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?