topic Re: Implementing dynamic hierarchical filtering in graph builder with local data filters in Discussions

Implementing dynamic hierarchical filtering in graph builder with local data filters

CSkjodt — Sat, 25 Nov 2023 11:25:41 GMT

Hello JMP Community,

I am working on enhancing the functionality of the Graph Builder in a JMP add-in (using JMP Pro 17.2) and require assistance in implementing a dynamic hierarchical filtering feature using local data filters. The solution I am looking for is similar to https://community.jmp.com/t5/JMP-Add-Ins/Dynamic-Subset-Add-In-Filterable-Data-Table-updated/tac-p/541349, but should be in the graph builder interface.

Currently, I have two local data filters in my setup:

one for Column X (Local Data Filter 1)
another for Column Y (Local Data Filter 2)

My objective is to establish a dynamic linkage between these filters. Specifically, when a selection is made in Local Data Filter 1 (Column X), Local Data Filter 2 (Column Y) should automatically update to display only col Y variables that are relevant to the chosen variable in col X i.e in the same row as the col X selection

I aim to integrate this feature into a JMP add-in, which will include a straightforward Graph Builder interface accompanied by these two interconnected local data filters. My goal is to expand this functionality to accommodate more than two local data filters in the future, and I therefore seek a generalized solution in JSL form.

Could you provide guidance or suggest the best approach to achieve this dynamic filtering interaction? Below is an example illustrating the basic structure of the Graph Builder with the two local data filters for :workflow_id, :id_type, which I want connected:

// Define table
dt = Data Table( "dtX" );

Graph Builder(
Size( 604, 622 ),
Variables(
X( :cumulative_time_days ),
Y( :var1),
Overlay( :id )
),
Elements( Line( X, Y, Legend( 16 ) ) ),
Local Data Filter(
Add Filter(
columns( :workflow_id, :id_type ),
Display( :workflow_id, N Items( 10 ), "List Display" )
)
)
);

Any insights or suggestions would be greatly appreciated!

Thank you.

Re: Implementing dynamic hierarchical filtering in graph builder with local data filters

jthi — Sat, 25 Nov 2023 12:31:51 GMT

Maybe making the filter conditional is what you are looking for?

Names Default To Here(1); 

dt = open("$SAMPLE_DATA/Big Class.jmp");

gb = dt << Graph Builder(
	Size(525, 488),
	Show Control Panel(0),
	Variables(X(:weight), Y(:height), Overlay(:sex)),
	Elements(Points(X, Y, Legend(9)), Line Of Fit(X, Y, Legend(11))),
	Local Data Filter(
		Conditional,
		Add Filter(
			columns(:sex, :name),
			Display(:name, N Items(15), Find(Set Text("")))
		)
	)
);

Re: Implementing dynamic hierarchical filtering in graph builder with local data filters

CSkjodt — Sat, 25 Nov 2023 22:01:23 GMT

It was! Mindblowing that I have missed this, beautiful.

Thanks a lot Jarmo

Re: Implementing dynamic hierarchical filtering in graph builder with local data filters

Jed_Campbell — Wed, 16 Jul 2025 16:32:29 GMT

This link by @pmroz might also be useful (with some adaptation to your situation) if you want the search results to update as you are typing: Solved: Searching elements in listbox - JMP User Community