cancel
Turn on suggestions
Auto-suggest helps you quickly narrow down your search results by suggesting possible matches as you type.
Showing results for 
Show  only  | Search instead for 
Did you mean: 
Try the Materials Informatics Toolkit, which is designed to easily handle SMILES data. This and other helpful add-ins are available in the JMP® Marketplace
Choose Language Hide Translation Bar
mcjenkins
mcjenkins
Level I

How do I plot "spiderdiagrams" in JMP

Jan 10, 2018 11:05 AM (5399 views)

Hello,

I have a large geochemical dataset that I am attempting to plot in JMP13. I use JMP for most of my geochemical plots but I have yet to figure out how to do so-called "spiderdiagrams." Following the advice of another post I found, I transposed my data table and was able to plot things that looked like spiderdiagrams using the graph overlay tool. This allowed me to plot the data and would work fine as a solution if I had a small dataset. Using this method, everything is grouped by element rather than sample ID so when I click on one point I select all of the points of that element group (i.e. if I click on one Au datapoint, all of the Au datapoints are selected rather than the points that correspond to one sample). Ideally, I would like to be able to select all of the datapoints for a given sample (i.e. Pt-Pd-Rh-Ru-Au points) so that I can begin to divide all of the samples into subgroups.

 

Untitled2.jpg

 Please, does anyone have any suggestions for how I can group the connected points so I can begin to sort them into lines of similar slope and appearance.

 

Thank you!

 

 

0 Kudos
2 REPLIES 2
pmroz
Super User pmroz
Super User

Re: How do I plot "spiderdiagrams" in JMP

Created: Jan 10, 2018 11:22 AM  |  Last Modified: Jan 11, 2018 6:24 AM (5394 views)  |  Posted in reply to message from mcjenkins 01-10-2018

You can try clustering the data using the approach outlined here (thanks Jeff P and David B!)

https://community.jmp.com/t5/Discussions/Clustering-X-Y-graphs/m-p/46916#M26732

 

Bill_Worley
Staff Bill_Worley
Staff

Re: How do I plot "spiderdiagrams" in JMP

Jan 11, 2018 10:09 AM (5335 views)  |  Posted in reply to message from mcjenkins 01-10-2018

I recently was working with a similar type data set and I used the Parallel Plot in Graph Builder to achieve a plot like the one you show below.  In Graph Builder highlight the columns of interest along with sample ID and drag them to the X axis drop zone.  From there select the Parallel Plot icon on the upper right side of the icons list.  This should generate the plot.  From there go back to your data table and select Rows > Data Filter.  Add sample ID to filter on.  When the filter option comes up make sure you have "Select" checked.  Now you have to make sure both your Data Filter and Graph Builder are visible together.  You should be able to put them side-by-side in the same window.  Go to your list of sample ID's in the Data Filter and click on the one you want to see.  You should have a single line in your plot showing with all others grayed out.  I tried local data filter in Graph Builder but could not get the single sample view I was hoping for.  Maybe someone else out there has a better idea there.

If you only want to see the one line make sure to check "Show" and "Include" in the  data filter as well.

 

@pmroz made a great suggestion for clustering as well that will help you see "like" samples.  You can then drop the cluster variable into Group X or Group Y to further break things out. 

 

HTH

Bill