JMP User Community

Latest Discussions

Lot Geneaology

Anyone have tips for organizing lot genealogy in JMP? For example, DP batches that contain many (different types and lots) of excipients. And the excipients have COA values that we want to track.

I'm assuming just multiple row entries for a DP lot on the left, working to more granular information in columns to the right. Is this the best way to track and visualize?
Kristen_C

Discussions |
Sep 30, 2022 12:54 PM

1977 views | 5 replies
Table Update from Access Database do not work with jmp 16

In our company there is an access database for rheology measurements. We can update rheology jmp tables from this database file (.mdb) by using jmp 14.3. Now we are using jmp 16.2 and the update script do not work anymore. Every time I have to open jmp 14 to update the tables. Current Data Table() << Update From Database( "DSN=Test;DBQ=filelink\filelink\file.mdb", "SELECT * FROM [file]" )
Metin_Tueluemen

Discussions |
Sep 30, 2022 8:14 AM

821 views | 1 replies
Need to create a column based on sequence of variable appear in another column

Hi All,
I want to create a column based on :Client_ID and how many times ( a number of sequence is counted as 1 count only, see the the :Comment column) it is appearing in the data set. My requirement is :Final Requirement and would be happy to have :Required Column 1 as well. I can not re-arrange/sort the data.Any help please ?Many thanks, -HSS

HSS

Discussions |
Sep 30, 2022 6:52 AM

3240 views | 8 replies
How to stretch GB to fill all available space?

Let's say I have a 3 column Line Up box with some display boxes, and then as a second row I have an Unlineup Box with a Graph Builder inside.Example can be seen by running this script:dt = New Table( "DEMO", Add Rows( 10 ), New Column( "Category", Character, "Nominal", Set Values( {"A", "A", "A", "A", "A", "B", "B", "B", "B", "B"} ) ), New Column( "X", Character, "Nominal", Set Val...
miguello

Discussions |
Sep 30, 2022 6:21 AM

1875 views | 4 replies
Is there a way to make the rowstate handler less laggy?

Is it possible to make the rowstate handler only fire on mouse up or after a selection event is completed? The realtime event causes drag select from my graph to lag and makes the user experience unpleasant. I've gone so far as to completely rewrite a selection event in the mousetrap thing but I'm having trouble applying it to histograms and I don't even love how it's performing either. It would...
xxvvcczz

Discussions |
Sep 29, 2022 6:42 PM

5202 views | 11 replies

Previous
Next

Latest Discussions

Lot Geneaology

Anyone have tips for organizing lot genealogy in JMP? For example, DP batches that contain many (different types and lots) of excipients. And the excipients have COA values that we want to track.

I'm assuming just multiple row entries for a DP lot on the left, working to more granular information in columns to the right. Is this the best way to track and visualize?
Kristen_C

Discussions |
Sep 30, 2022 12:54 PM

1977 views | 5 replies
Table Update from Access Database do not work with jmp 16

In our company there is an access database for rheology measurements. We can update rheology jmp tables from this database file (.mdb) by using jmp 14.3. Now we are using jmp 16.2 and the update script do not work anymore. Every time I have to open jmp 14 to update the tables. Current Data Table() << Update From Database( "DSN=Test;DBQ=filelink\filelink\file.mdb", "SELECT * FROM [file]" )
Metin_Tueluemen

Discussions |
Sep 30, 2022 8:14 AM

821 views | 1 replies
How to stretch GB to fill all available space?

Let's say I have a 3 column Line Up box with some display boxes, and then as a second row I have an Unlineup Box with a Graph Builder inside.Example can be seen by running this script:dt = New Table( "DEMO", Add Rows( 10 ), New Column( "Category", Character, "Nominal", Set Values( {"A", "A", "A", "A", "A", "B", "B", "B", "B", "B"} ) ), New Column( "X", Character, "Nominal", Set Val...
miguello

Discussions |
Sep 30, 2022 6:21 AM

1875 views | 4 replies
How to have a mixture of mixtures design

Hi, I am developing a cell culture medium based on 4 prototypes. These 4 prototypes are basically contain same components but at different level, Prototype 1 is lean, prototype 2 is rich in amino acid, prototype 3 is rich in vitamin and prototype 4 is rich in trace element. I will mixture different level of the 4 prototypes to have a new mixture media.I understand this is a mixture of mixtures des...
loganshawn

Discussions |
Sep 29, 2022 12:06 PM

4717 views | 3 replies
Matched pairs reference frame

I don't seem to be able to get the reference frame to show up on the resulting graph by selecting a preference (see screenshot)? Is this a feature, a bug, or my ignorance of what option to select? (I can turn it on using the Little Red Triangle [because that's my friend!].)
sfigard

Discussions |
Sep 29, 2022 6:17 AM

1471 views | 3 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

592 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

629 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

669 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

737 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

738 views | 0 replies