JMP User Community

Latest Discussions

Expr and Name Expr

Hello, I am analyzing larger amounts of data, 350k rows. For each row, the code runs a loop to calculate the unique delta between table 1 and table 2 and then add that delta to the column of the main data table. Something is not correct in the below code. Any suggestion? Names Default To Here( 1 ); dt1 = Data Table( "dt_ref" ); dt2 = Data Table( "Data table" ); digt = 5; itsel1 = {"Currents A", "...
Jackie_

Discussions |
Nov 13, 2023 10:18 AM

1790 views | 4 replies
Run Order with JMP DOE

Hi, I have to set-up a DOE (Response Surface) where I have a machine as blocking factor. Since it is very time consuming to change the temperature of the machine, I want to have the run order of the DOE with temperature going from low to high. Right now, when I design the DOE, JMP gives me high, low and then intermediate.
bbenny7

Discussions |
Nov 13, 2023 9:38 AM

1448 views | 1 replies
How to programmatically traverse a Graph builder tree structure and associate frameboxes with their titles.

I have a piece of analysis (see below) where I want to annotate specific charts using a script I have written. For example, I want to add annotation to XXX104 and XXX107. On both of these charts I will add a custom graphic and text to identify a cluster of points I want to draw attention to. Using the command '<< show tree structure' I can identify the frameboxs which have each chart. However, I...
thickey

Discussions |
Nov 13, 2023 5:26 AM

2513 views | 4 replies
Linking rows to portions of images

Hello - Kindof a weird question, but I'm trying to include my lab notebook pages in my project file, because its very hard for someone else to look through a 1000 page lab notebook and pair it with a table if they don't know where to find what they are looking for. I'd like to link rows of experiments in one table to portions of images of pages. I know this is trivial with whole images, just make ...
ehchandlerjr

Discussions |
Nov 13, 2023 5:20 AM

828 views | 1 replies
How to add special tags on top of this mapping?

For example, we use Big Class.jmp data to make height and weight distribution maps according to different ages.
Can you show the starting and ending heights of different ages in the table in the order of row numbers?
Of course, there is no limit to how it can be displayed.Screenshots just make the requirements clear.Thanks!dt = Open( "$SAMPLE_DATA/Big Class.jmp" ); ca = "R"; New Column( ca ); Column...
lala

Discussions |
Nov 13, 2023 2:20 AM

2751 views | 8 replies

Previous
Next

Latest Discussions

Expr and Name Expr

Hello, I am analyzing larger amounts of data, 350k rows. For each row, the code runs a loop to calculate the unique delta between table 1 and table 2 and then add that delta to the column of the main data table. Something is not correct in the below code. Any suggestion? Names Default To Here( 1 ); dt1 = Data Table( "dt_ref" ); dt2 = Data Table( "Data table" ); digt = 5; itsel1 = {"Currents A", "...
Jackie_

Discussions |
Nov 13, 2023 10:18 AM

1790 views | 4 replies
Linking rows to portions of images

Hello - Kindof a weird question, but I'm trying to include my lab notebook pages in my project file, because its very hard for someone else to look through a 1000 page lab notebook and pair it with a table if they don't know where to find what they are looking for. I'd like to link rows of experiments in one table to portions of images of pages. I know this is trivial with whole images, just make ...
ehchandlerjr

Discussions |
Nov 13, 2023 5:20 AM

828 views | 1 replies
Save small datatable to Journal

I've been at this for a while and I know it's doable but I can't seem to get it to work....I can save my Graphs to a journal but can't append a small data table (summary table) to the journal..... --- any hints?
twaintwist

Discussions |
Nov 12, 2023 1:10 PM

9658 views | 9 replies
Can the X group name text orientation of this Graph Builder be set to vertical?

Thanks!dt = Open( "$SAMPLE_DATA/Big Class.jmp" ); ca="tem";New Column(ca);Column(ca)<<Formula( char(age)||"longlong" );dt<<run formulas;Column(ca)<<deleteFormula; p1 = dt << Graph Builder( Size( 300, 400 ), Show Control Panel( 0 ), Legend Position( "Inside Bottom Right" ), X Group Edge( "Bottom" ), Variables( X( :weight ), Y( :height ), Group X( :tem, Size( 161 ) ), Color( :sex ) ), Elements...
lala

Discussions |
Nov 12, 2023 8:30 AM

1980 views | 6 replies
Creating a column with concatenated values

Hey all,
I'm trying to create new column which will include to rows/values. The first one is a variable and the second one is a concatenated expression of two variables.No matter what I tried, I get an empty cell in the concatenated value. Can you please advise? Example of what I tried:stiop=10; stiPLL=20; stiPHL=30;
STIarg={char(stiop),char(stiPLL) ||"<PL<"|| char(stiPHL)};Operations<<
New Column( ...
Stas

Discussions |
Nov 12, 2023 6:40 AM

1605 views | 4 replies

Previous
Next

Latest Discussions

Getting NonEstimable values when crossing variables due to control setup

Hi, I'm working on a dataset where we are testing the effects of 2 treatments and the delay between them, and I'm trying to figure out how to line up my variables so I can do a Dunnett's test against various controls. We are giving animals a dose of drug A (Variable A), waiting some time (T), and then giving them a dose of drug B . If the animal is NOT given drug A (= 0), then T doesn't have a m...
eberndl

Discussions |
Nov 10, 2023 10:48 AM

628 views | 0 replies
Column Format in Distribution not following Data Table Column Format

Hello Expert, I have an issue with "PERCENT" in JMP.1-2: I have defined the column "Data" from rate to be in "Percent" & Dec "2" in the data table.3: But, when I plot Distribution --> the quantiles "Data" values do not follows my instruction that the data is already in "Percent" & Dec "2".4: The summary statistics for basic statistics also does not follow the data format that I've defined earlier...
WebDesignesCrow

Discussions |
Nov 9, 2023 7:11 PM

582 views | 0 replies
Nested Cross-Validation Script?

Hello, how can I apply nested cross-validation outside of the model screening platform? I would strongly suggest to extend the Make-Validation-Column Section by an option to automate nested cross validation for all predictive models. It would be cool to just select a validation column (or 2 validation columns) for nested cross-validation. In the meantime, could you please provide me with an exampl...
MarkusJH

Discussions |
Nov 2, 2023 3:21 AM

719 views | 0 replies
Functional data in rows-as-functions, but different rows have different step size

Hello - I have a table with 250+ experiments and thousands of columns, about 100 that are for either raw or transformed data, and then I'm taking output from an xml file with functionally "spectral data" (XRD diffractograms for anyone that is familliar), and just laying that on its side in row form (more explanation if needed in another question I posted here: https://community.jmp.com/t5/Discussi...
ehchandlerjr

Discussions |
Oct 28, 2023 12:33 PM

688 views | 0 replies
How to adjust the factor range for specific factors within an ongoing DOE

Hi, I designed a DOE that has two independent buffers. This DOE will range components in each buffer which will be used in a processing step sequentially. IE, buffer A, followed by buffer B. We already prepared for the DOE, and formulated the A buffers as per the recommended design. For the B buffers, we intended on ranging 2 components but later decided to reduce to ranging one component, and als...
MetaLizard62080

Discussions |
Oct 26, 2023 5:25 PM

649 views | 0 replies