JMP User Community

Latest Discussions

Use JSL to recode a column with user input

Hi, I'm looking to use JSL to recode a column (creating a new column), based on user input. I have data that we get from a batch process, and we can identify each batch based on time, so I can clean up the data to look something like this:What I would like to do is then prompt the user for input, in this case the lot number that corresponds to each batch, which would then be used to recode a new ...
ddegennaro

Discussions |
Sep 26, 2022 7:33 AM

1331 views | 2 replies
Dynamic Limit Graph

I have a dataset 4 columns Index, Measurements, Lower and Upper Limits,I cant seem to figure out how to represent them in a single graph ... Thanks
Flavy

Discussions |
Sep 26, 2022 4:16 AM

1522 views | 3 replies
How do i rename column header name with existing string?

Hi, I am trying to rename multiple column header name that consists a particular string but rename it with the existing string while remove the front portion of the string. Example: ABC_12::ABCD_AB_ABCDEF_A_ABCDE_X_X_A1_1234_ABCD_TESTING_AB_TEST_ABCD_TESTED_AB_A1 --> TESTING_AB_TEST_ABCD_TESTED_AB_A1 The number of character on the first part of the string (orange) will always be consistent, the 2n...
kuanaunwei

Discussions |
Sep 26, 2022 3:09 AM

900 views | 1 replies
Design Evaluation of a Manually Built DoE

Hello, I was wondering if it was possible to get to the design evaluation page (picture 1) of a manually built DoE in JMP (picture 2)? Thank you!
DashNap

Discussions |
Sep 25, 2022 7:33 PM

1846 views | 3 replies
JSL: add reference lines to Graph Builder Report depending on value of local data filter

GObj = Graph Builder( Size(1221, 652), Show Control Panel(0), Variables(X(:Date), Y(:Close_s)), Elements(Box Plot(X, Y, Legend(5))), Local Data Filter(Add Filter(columns(:Date, :Name), Where(:Date >= 01Jun2022), Where(:Name == "Anglo American"))), SendToReport( Dispatch( {}, "Graph Builder", OutlineBox, {Set Title("Variability Plot Low Close and High values for the day"), Image...
HansD

Discussions |
Sep 25, 2022 3:46 AM

2081 views | 2 replies

Previous
Next

Latest Discussions

Plenary talks from JMP Discovery 2022

Hello JMP Community - I am looking for a link to the recordings of the JMP Plenary from Tue and Wed 20 and 21 Sep 2022 - I can't seem to find on the Discovery Americas 2022 community page. Excellent conference so far! Great job Steering committee and JMP Staff.
pattidimcneill

Discussions |
Sep 23, 2022 12:34 PM

1010 views | 3 replies
how to select only those samples that meet two or more criteria

i want to create a new column using Day1_Orig values wherein there are both Day1_Orig and Day1_Repeat values for the same SUBJID. So for instance, lines 113 and 114 have same SUBJID, so the new column would record the value of the Day1_Orig value in line 113 (834), but as there is no corresponding Day1_Repeat value for line 107 (641), this Day1_Orig value would not be included in the new column.
dhagman

Discussions |
Sep 23, 2022 10:41 AM

1369 views | 5 replies
scatterplot of adjusted effect for one predictor in a generalized regression model

I used generalized regression with LASSO for variable selection. The reduced model now includes 3 predictors. How could I make a scatterplot of the effect of one predictor adjusted for effects of other two predictors in the model? Thank you!
vicvo

Discussions |
Sep 23, 2022 5:08 AM

566 views | 1 replies
How do I use a relative folder path in multiple file import?

Members of my group use a Sharepoint workspace that includes raw test data that we'd like to import and process in JMP. Our shared script for processing that data is stored within the Sharepoint workspace itself, which seems to present problems for defining the folder path for the multiple file import function. It seems that Microsoft defines the path for a mounted Sharepoint or OneDrive folder as...
alan_h

Discussions |
Sep 22, 2022 11:03 AM

1618 views | 3 replies
Using FORMULA for pasting the alues from one column based on the other column using IF statement

I am trying to fill the column of Slopes_1 and Intercept_1 (1000 rows) from Slopes and Intercept (36 rows), respectively based on if Cycle 2(1000 rows) matches Cycle 3 (36 rows)Can you suggest a formula to be inputted in Slopes_1 and Intercept_1 ?
AlphaPanda86751

Discussions |
Sep 21, 2022 8:11 AM

747 views | 2 replies

Previous
Next

Latest Discussions

Model classification thresholds add-in display "negative" probability

Hi, I've been looking at this add-in which is very useful.https://community.jmp.com/t5/JMP-Add-Ins/Exploring-Model-Classification-Thresholds/ta-p/66964 In our case we don't have a probability but instead we have a status and a measurement that ranges between -10 and 10.I want to adapt the script so that the slider can move between -10 and 10 (I've already done it and it works). However the "Probab...
Agustin

Discussions |
Sep 13, 2022 6:43 AM

414 views | 0 replies
wrap: hide sub-titles?

In GRaph Builder, "wrap" is a nice option to split a data set into small pieces and generate many sub-plots.
But sometimes, the window is just filles with the "titles" of the sub-plots an there is no space left for the plots.
Is there an option to hide the titles of the subplots?
In the "wrap" context menu, there is an option to remove the "title" (here: "data"), but not the sub-titles.
And in the red...
hogi

Discussions |
Sep 11, 2022 8:53 AM

485 views | 0 replies
How to transform least square means from Turkey table after box cox transformation

Hello Everyone, I am running a three-way ANOVA with data expressed in percentage, but the data set is not normal. Since I have zeros, I first add a constant 0.00001, then I fit the model, and in the least square fit window, I used the box cox transformation to do a better fit. I know if I ask to save the predicted values, it will save the back-transformed data, but is there an option for JMP to sa...
Viniaze

Discussions |
Aug 27, 2022 9:14 AM

517 views | 0 replies
XGBoost Add-In for JMP Pro no test set result in model screening

I'm using model screening and include XGBoost as a method. However the result from XGBoost are only shown in Train set and Validation set.Why the result of XGBoost for test set is not shown?
TasapornV

Discussions |
Aug 25, 2022 12:45 AM

565 views | 0 replies
JMP Pro, Dantzig selector: how do I improve computational time

Hello JMP community members. Concerning the use of the Dantzig selector on big and sparse datasets.I wondered what features would be at disposal to tune the computational time.Right now it takes about 40 minutes to get a result back for a problem with 380 rows and 149 non-singular parameters. This makes me wonder about the options available to tweak the computation time. I was thinking about redu...
Not_A_Student

Discussions |
Aug 12, 2022 7:49 AM

573 views | 0 replies