nav[aria-label="Primary Navigation"] { padding: 0; & ul { list-style: none; width: 100%; display: flex; flex-direction: row; justify-content: start; align-items: start; gap: 30px; padding: 0; & li { margin: 0; } & ul li { list-style: none; } } }

Using graph builder to create graphs with grouped Y data

cchb

Hello,

I am a tropical ecologist specialising in the Amazonian canopy. I am writing my PhD thesis and using JMP Pro (I'm a fairly new user with no programming experience) to run PLS and other analyses on my data. I have a large dataset of leaves grouped by tree, leaf canopy level (sun or shade) and leaf age. For one of my first analyses I have 12 trees with 4 trees having both sun and shade leaves and the rest just sun leaves. I need to create graphs for different leaf traits such as leaf water content, leaf thickness, leaf fresh and dry weight, %Carbon content, etc. etc., these graphs need to be built such that:

X axis = leaf age

Y = leaf trait (e.g. leaf thickness) grouped by tree and by sun and shade canopy position

I have been trying to create these graphs but I keep getting a graph that splits the Y scale for each tree and when I try to put the sun and shade grouping into the graph it all just gets even worse. I would be very grateful if someone could advise me on how to create these Y-grouped graphs and how best to automise the production of numerous graphs. Many thanks in advance for the help!;

Accepted answers

XanGregg

Hi Cecilia,

For getting all trees on one graph, you can put Tree in the Overlay slot (make sure the Tree column is marked as nominal since continuous variables can get binned otherwise). Then the Canopy variable will have to be in one of the Group X or Group Y slots.

If you really want all the lines in one plot, you can create a new variable that concatenates Tree and Canopy and then overlay by that variable. To do that, create a new character column and give it a Formula that concatenates the two other columns. Something like :Tree || " " || :Canopy. "||" is the text concatenation operation.

You can use a similar method to append the tree age values: :Age Class || "(" || Char(:age in weeks) || ")"

You can control the SU/SH order by adding a Value Order property to the Canopy column in the Column Info dialog.

For creating lots of similar graphs, you can use Column Switcher (under Red triangle > Script > Column Switcher) to do that interactively or use JSL scripting to do it programmatically (Red triangle > Script > Save to Script Window, then edit the Y name).

xan

All comments

Jeff_Perkinson

Hi CCHB,

I'm not sure exactly what you're looking for.

I mocked up some data and have attached it here so you can see what I started with.

Here's a graph I created using the X Group role at the top of the graph. This gives you one graph for each Tree.

I also used the Sun or Shade column in the Overlay role to get one line for Sun and one for Shade for the trees that had both.

Alternatively you could use the Sun or Shade column in the Y Group role on the right side of the graph and get this.

If I've not guessed correctly, describe more completely what series of graphs you'd like and we can try to show you how to create them.

-Jeff

Trees.jmp.zip

cchb

Hola Jeff,

Many thanks for your reply and for taking the time to create example graphs, and apologies for not supplying enough information in my original post. Your graphs actually illustrate very well the problems I have been encountering. Using you graphs as an example:

1. Thanks for the tip on using the Overlay role for the sun and shade leaf canopy position, that solves one problem. I have been using the Y group role at the left of graph for the different trees which gives me a graph that looks like yours but arranged horizontally rather than vertically. I have updated my graph using the Overlay role as shown below:

4024_Screen shot 2013-08-14 at 14.16.12.png

However, I would like the above to:

1. be one single graph rather than a graph for each tree.

2. I would like to add the equivalent number of weeks that each leaf age class represents in parenthesis, e.g. Y1(1), Y2(2), etc. I have this data in a separate column in my data table, how do you concatenate two or more columns in JMP Pro?

2. I have also re-created your second graph (I quite like this graph as it would be less busy than the previous one) as follows:

4026_Screen shot 2013-08-14 at 14.16.38.png

I would also like the above:

1. to be one single graph instead than one graph for each tree

2. to switch the order of the canopy position so SU is on the left and SH is on the right. I have reversed the order of the X and Y axis but I can't find this option for the X and Y grouping roles.

After organising the graphs to display the information correctly I would like to find a way of creating a whole lot of similar graphs but just changing the Y axis.

I hope that the above clarifies my questions and I thank you again for your help.

Cecilia

XanGregg

Hi Cecilia,

You can use a similar method to append the tree age values: :Age Class || "(" || Char(:age in weeks) || ")"

You can control the SU/SH order by adding a Value Order property to the Canopy column in the Column Info dialog.

xan

cchb

Hola Xan,

Many thanks for your recommendations, they were spot on. With both your and Jeff's help I have almost arrived at the graph I wish to create. Below is the graph I have come up with so far:

4042_Screen shot 2013-08-15 at 22.47.56.png

I have three further questions about these graphs:

1. How do I get rid of the X Group legend "SU/SHCanopyPos"? I have tried double clicking and right clicking the legend and playing around with the script (with my non-existent programming skills!) and I couldn't find a way of getting rid of this legend.

2. How can I superscript some of the text (e.i. units such as m2) in the Y legend?

3. This question I think is a bit more tricky: as you can see on the X Groupings, after I concatenated the "age in weeks" data onto the leaf age classes I ended up with two separate O/S1 age classes. This is because the sun leaves of this age class live shorter lives (61 weeks) than the shade leaves (79 weeks). Is there a way I could get just one O/S1 age class for each canopy position but with correct "age in weeks" for each one?

Finally, I used the Column Switcher to create similar graphs but didn't like it so much, I found it a bit cumbersome. So, I tried the scripting option and found it much more straight forward.

Many thanks again for the help,

Cecilia

cchb

Thank you so much for your prompt reply. Indeed, some of the numeric columns had gone into character mode. I have now corrected this and my graphs are making sense and showing amazing patterns, many, many thanks!!