JMP User Community

Latest Discussions

Removing first 4 Characters from a column along with a special character

Hello, I have a column that is a sample description and there is always a ~numbers before the description that I would like to remove from all rows. Only one row has the "~" in it. For Example. Sample:126: Description AB291: Description XYZ~619: Description Is there a JSL script that would remove the "~", first 3-digit numbers, and the ": " (including the space) from all rows within the Sample col...
Hams

Discussions |
May 10, 2023 2:10 AM

2336 views | 3 replies
Create Column with Values Based Off Existence of Other Rows & Logic

Hello anyone, I am trying to create a formula or script that will set a certain value ("Good", "Bad", or "N/A") for each row based off if there is another row in the table with values matching logic that uses the current row as an input. I have a script that does just this by using nested For loops when using a small subset of the full datatable. However, with the full datatable I am trying to use...
ATAbbott

Discussions |
May 9, 2023 10:38 PM

1669 views | 3 replies
Changing one color from the legend that is set to JMP Default for multiple graphs in variability chart

Hi all, My question is in two parts and ideally #1 can be solved, its okay if you can't figure out #2. I appreciate any and all help!1. How can I make one of the categories within each legend be the color black and not the default color jmp assigns. Example: Make Chrysler the color black in the first legend, town car black in the second, 90 black in the third, 2 black in the fourth, and van black...
neelsrejan

Discussions |
May 9, 2023 3:31 PM

1229 views | 2 replies
Functional Data Explorer: applicable to study impact of a non-constant variable on a function?

Hello, We would like to understand what may have caused a change in aspect of an online process data curve over several runs.The variable that we have identified as having changed over the past runs was the stirring speed. This variable however is not constant over time, but is varying over time. It is part of a regulation cascade to maintain another variable constant (the dissolved oxygen). This ...
cbaril

Discussions |
May 9, 2023 10:46 AM

1237 views | 2 replies
optimizing decisions

I am trying to see how one would use JMP to optimize decision-making. I made some progress but figured that there are entire industries based around this theme (!), so maybe no need to invent the wheel here: I want to decide which is the best conservation strategy given a set of inputs: a facility's resources, the nature of the environmental problem, and things like that (all on a common scale of ...
abmayfield

Discussions |
May 9, 2023 8:49 AM

1061 views | 2 replies

Previous
Next

Latest Discussions

Create Column with Values Based Off Existence of Other Rows & Logic

Hello anyone, I am trying to create a formula or script that will set a certain value ("Good", "Bad", or "N/A") for each row based off if there is another row in the table with values matching logic that uses the current row as an input. I have a script that does just this by using nested For loops when using a small subset of the full datatable. However, with the full datatable I am trying to use...
ATAbbott

Discussions |
May 9, 2023 10:38 PM

1669 views | 3 replies
optimizing decisions

I am trying to see how one would use JMP to optimize decision-making. I made some progress but figured that there are entire industries based around this theme (!), so maybe no need to invent the wheel here: I want to decide which is the best conservation strategy given a set of inputs: a facility's resources, the nature of the environmental problem, and things like that (all on a common scale of ...
abmayfield

Discussions |
May 9, 2023 8:49 AM

1061 views | 2 replies
Loop through cols/rows of two separate tables for getting arguments into a function

I have got a working function which plots trends and distribution for measured parameters (columns in a table1) using test limits (LSL, USL in another table, table2). Names Default To Here (1); getTrendChartAndDist = Function({colName, LSL, USL}, {TrendDistChart}, New Window(""||colName||" Trend & Distribution", Graph Builder( something here ..... ); return(TrendDistChart); );In order to plot...
Neo

Discussions |
May 9, 2023 8:27 AM

993 views | 1 replies
Design of experiments

Hi everyone, first of all, excuse my english because I am not a native english speaker. I am a beginner in the field of design of experimens and this is why I am looking for insights. My problem is the folowing: 1. I need to optimize the concentration of 7 proteins contained in the cell culture medium we use2. We know that all these 7 proteins have an significant effect on the response ( yield)3...
Ekokase

Discussions |
May 9, 2023 8:25 AM

4567 views | 11 replies
Custom DOE - best approach for categorical and mixture factors

I’m doing a custom DOE and would appreciate any tips or pointers on creating optimal recipes.Is there a better DOE approach than the one constructed, or other factors to bear in mind? Responses:Maximise different nutritional valuesMinimise quantity of saltReach target of taste and smell score Factors:Categorical –> Texture 2 levels : T1 / T2Categorical --> Aroma 3 levels: A1/ A3/ A3MixtureIngred...
SarahD

Discussions |
May 9, 2023 6:48 AM

2797 views | 3 replies

Previous
Next

Latest Discussions

how to read the output from Johnson-Neyman plot and floodlight analyisis?

hi,I have got an add-in from https://community.jmp.com/t5/JMPer-Cable/Who-what-why-and-how-Tools-for-modeling-and-visualizing/bc-p/624293#M842 to implement floodlight analysis through Johnson-Neyman Plot. according to the table of the example from the linkage above; what does "_c" mean? such as "meaning_c" and overwhelming_c"? focus on my own study, I got a moderator called "SE" which is a contin...
Rongyu_Kuang

Discussions |
Apr 23, 2023 8:56 AM

1196 views | 0 replies
Goodness of Fit statistics for GLM Probit Fit: Deviance or Pearson?

Which GoF statistic is best to use (Pearson or Deviance) when the results disagree? Is one better suited for Probit than the other? I'm using JMP Pro 17.0.0
DBerger

Discussions |
Apr 18, 2023 12:50 PM

775 views | 0 replies
Interpreting Pairwise Tukey HSD t ratio in Zero-Inflated Poisson

The context of my data is from an e-commerce website. I am measuring the number of errors made based on different independent variables: Filtering technique (Alphabetical, Relevance and Search) and Number of Items added (Add one at a time, or add multiple items to cart at once). As the number of errors made is 0 most of the time, I have opted to use the Zero Inflated Poisson Regression. When I per...
ConstructChart2

Discussions |
Apr 13, 2023 12:46 PM

989 views | 0 replies
oci connection example

I am looking for an example of how to connect to oracle data with JMP 16 via oci. I have seen notes indicating that it is a far faster connection.
sconard

Discussions |
Apr 10, 2023 10:40 AM

657 views | 0 replies
Criblage des processus

Bonjour à tous,Est-il possible de mettre dans le criblage des processus le format/la colonne de notre choix dans le module « dernière alarme ». Pour ma part j’aimerais pouvoir y mettre une colonne Date pour pouvoir contrôler à quels jour interviennent mes dernières alarmes.Merci pour votre aide.
hcarr01

Discussions |
Apr 3, 2023 2:41 AM

705 views | 0 replies