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
I create a graph, and when I go to select a portion of it, it highlights the entire excel sheet. I remember from demo that you should be able to select a segment and have it only highlight the data directly relating to that segment. What am I doing wrong here?
I would also like to know if there is any way to have JMP find the peak data from multiple points on the same line and display them in the graph?
Selecting a line will select all points that make up that line. You would have to have points on the line in order to only select that region of the line.
Hope That helps.
Chris
Chris Kirchberg, M.S.2 Data Scientist, Life Sciences - Global Technical Enablement JMP Statistical Discovery, LLC. - Denver, CO Tel: +1-919-531-9927 ▪ Mobile: +1-303-378-7419 ▪ E-mail: chris.kirchberg@jmp.com www.jmp.com
1. I added in the code to change the marker size and transparency
2. You may not have noticed the following issue, however, in the new columns you were creating, the formulas had the values of dt and i in them. Those are memory variables that can possibly change. (i.e. you save the table, start up a JMP session in the future, open the data table, and the columns would cause an error, because the variables dt and i are no longer available). So I changed the code to make the formulas to have hardwired values.
Here is the code. I made a mockup data table to test the code out, so there still maybe as issue or two.
Below is a chart that has had some points selected, and as can be seen on both the chart and the data table, which points have been selected. However, you will need to provide more information about exactly what chart you were using, and what the data table contains for one to attempt to determine what the issues may be. I suggest as your first step, that you read the Essential Graphing book provided with the install of JMP
Help==>Books==>Essential Graphing
Concerning your second question, yes you could determine selected points from a line, and have their values be displayed on the chart. This can be done by specifying what columns should be used for the label, and then selecting the data points to be displayed. Again, this is covered in the Essential Graphing book
It's a fairly simple graph with only two lines of data, it should be really simple but for some reason as you can see selecting just the peak highlights the entire spreadsheet.
The second part I'm looking more for a way to script it into the script I currently have, if I have to hunt down the data points and select them the point is already defeated, variables I know is the column it occurs in, that there will always be a 0 before each peak of reference, and that I only care about the highest point of the peak for each occurance on the line.
I'll take a look at the book of course, but time waits for no man and the purpose of this project is to streamline the tasks we already do, don't need JMP to hunt for values we already have in Excel, ya know ^.^
That's interesting - the same thing happens for me. I also notice that the lasso tool turns into a rectangle rather than a free-drawing polygon. But it only happens if the line option in Graph Builder is chosen rather than the points. I am guessing that with the line drawn for the mean of that variable, all points are highlighted because all the points are used to calculate the mean - but that is a guess and I'll be interested to see if someone can unravel the mystery. As for your other question, can you use some combination of ColMax and/or ColRank functions to get the points you are looking for?
Selecting a line will select all points that make up that line. You would have to have points on the line in order to only select that region of the line.
Hope That helps.
Chris
Chris Kirchberg, M.S.2 Data Scientist, Life Sciences - Global Technical Enablement JMP Statistical Discovery, LLC. - Denver, CO Tel: +1-919-531-9927 ▪ Mobile: +1-303-378-7419 ▪ E-mail: chris.kirchberg@jmp.com www.jmp.com
Well that answers the question, but presents a new problem. On the other hand now I know a really quick way to find the peak value without a lot of effort, however I would really like to be able to just select the segment of the line. The line graph is the best way to represent the data in this case because it's fluid flow, we collect data points along a timeframe, but the fluid is still flowing between those points, and also because it mirrors the way it's displayed in other formats so it's easy to see if you're looking at the right data, or if the data is significantly out of desired parameters. I wonder if there's a way to display it as a line, but treat it as points... *ponder* Well, anyway thanks for the information!
Okay, so I've modified my graph so it is also using points. However the points are enormous and clunk up my picture. Is there a way to graph the points smaller or even graph them but remove the visible points? I don't need the points, I just need the ability to select the specific segment of a line which doesn't let you do that. Thank you for your additional help!
Beautiful, now we're getting somewhere, I'm having trouble inserting the dialogue that comes up for that into my script. When I make that adjustment the script looks like this
but I'm having trouble figuring out where and how to insert the modifiers into my base script.
I'd love to better understand this, but understanding is less important than effect, for the moment ^.^ (saved as images instead of text because text was working strangely, text code to follow)