topic Re: Creating a dynamically linked table in Discussions

Creating a dynamically linked table

mostarr — Sat, 10 Jun 2023 23:34:20 GMT

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

Re: Creating a dynamically linked table

jthi — Tue, 27 Jul 2021 21:39:31 GMT

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

Re: Creating a dynamically linked table

mostarr — Tue, 27 Jul 2021 21:52:11 GMT

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?

Re: Creating a dynamically linked table

ledi_trutna — Tue, 27 Jul 2021 21:55:23 GMT

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.

Re: Creating a dynamically linked table

txnelson — Tue, 27 Jul 2021 22:46:43 GMT

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