topic Re: Graph Builder, Pie plot : How to keep all the elements of a group when filtering on groups that have a specific element ? in Discussions

Graph Builder, Pie plot : How to keep all the elements of a group when filtering on groups that have a specific element ?

CorentinL — Fri, 13 Dec 2024 12:24:23 GMT

Hi,

I'm looking for help in the Graphic Builder. I am using JMP 16.2.0.

I will use a table with two columns (Recipe, Ingredient) as an example. A recipe is composed of multiple ingredient, and an ingredient can be use in multiple recipes. The table is provided in Attachments.

In the Graph Builder, I put Recipe in Group X, Ingredient in X and choose a Pie Plot to see what ingredient is used in which recipe.

What I would like to do is to select an ingredient and it will keep the pie plots of all the recipes that use the ingredient. The pie plots should show all their ingredients .

For example, I want to see all the recipes that use Milk. If I add a local data filter on the recipe, the pie plot won't display all the ingredients for the Bechamel and Pancake.

What I would like to have as an output is something like this :

Is there an easy way to do that, without writing some JSL ? We can modify the table or work with the Graph Builder.

Thank you !

Re: Graph Builder, Pie plot : How to keep all the elements of a group when filtering on groups that have a specific element ?

jthi — Fri, 13 Dec 2024 12:37:51 GMT

I'm not sure if you can do this in JMP16 (I'm using JMP18), but you can create multiple response column of your Ingredients

Table attached with table script

Re: Graph Builder, Pie plot : How to keep all the elements of a group when filtering on groups that have a specific element ?

CorentinL — Fri, 13 Dec 2024 14:33:43 GMT

Thank you for the reply, this is a great solution indeed.

Unfortunately, it does not work in JMP 16.

I guess we'll need to update to a more recent version !

Re: Graph Builder, Pie plot : How to keep all the elements of a group when filtering on groups that have a specific element ?

jthi — Fri, 13 Dec 2024 15:09:12 GMT

Scripting is also an option but you said you wish to avoid it, so here is maybe an option which might work in JMP16 (it can be a bit clunky to use due to utilizing selection row state). If you can use Data filter instead of local data filter, you can do something like this

Create formula column like

Col Sum(Selected(), :Recipe) >= 1

Create Data filter (NOT LOCAL DATA FILTER) with ingredient

Create your graph WITH local data filter using your newly created formula column and set the value to 1

You can then collapse the local data filter and organize the windows side by side

One a bit annoying thing here is that there will be a selection and it will mess up if something is selected from the table / outside of data filter.

Re: Graph Builder, Pie plot : How to keep all the elements of a group when filtering on groups that have a specific element ?

txnelson — Fri, 13 Dec 2024 16:22:09 GMT

If you modify the data table with new rows and a new column, I can get it to work in JMP 16. You need to create a new row for each combination of ingredients for each ingredient in the recipe. So for Bechamel which has Milk, Flour and Butter

it has to be expanded to

And here is a script that will generate the expanded data table

names default to here(1);
dt=current data table();

// Start the new table
dtOut = New Table( "Expanded",
	New Column( "Recipe", Character ),
	New Column( "Ingredient", Character ),
	New Column( "Ingredients", Character )
);

// Find the different Recipies
summarize( dt, Recipies = By(:Recipe));

// Loop through the recipies 
For Each( {rec}, Recipies,
	// Find the ingredients for the current recipe
	dt << select where(:Recipe == rec );
	dtTemp = dt << subset( selected columns(0), selected rows(1));
	summarize( dtTemp, ingre=by(:ingredient));
	
	// Loop across each ingredient and add the rows to the data table
	For Each( {item}, ingre,
		dtTemp << New Column("Ingredients", character, set each value(item));
		dtOut << concatenate( dtTemp, Append to First Table(1) );
		dtTemp << delete columns(:Ingredients);
	);
	close( dtTemp, nosave );
);

Re: Graph Builder, Pie plot : How to keep all the elements of a group when filtering on groups that have a specific element ?

hogi — Fri, 13 Dec 2024 17:31:35 GMT

GraphBuilder + Multiple Response : VERY (!) useful!
it got available with JMP17:

the upgrade is free of charge. Maybe take 2 steps and get all the great features of JMP18?

Re: Graph Builder, Pie plot : How to keep all the elements of a group when filtering on groups that have a specific element ?

CorentinL — Mon, 16 Dec 2024 09:01:46 GMT

Thank you both @jthi @txnelson for your creative solutions, I will adapt the script to my real data and execute it when needed.

@hogi I will push for a JMP update !

Have a great week !