JMP User Community

Latest Discussions

Counting and Using Row Identifier

Hello All,

Wanted to ask a question regarding counting of rows. I am attaching a data table which should hopefully illustrate the example.

So I have data where the main variable is density of features. There is a unique value of the density per each ROI, per each sample (ID). In the normalized variable I am taking each density value per each ROI per each sample with unique ID and dividing by the wh...
Ekarshalev

Discussions |
Feb 7, 2023 8:58 AM

4963 views | 7 replies
Using Char to compare numeric and character values

Hi,Is it possible to compare numeric and character values? I want to compare two columns (identical or different values). One column has a numeric date and one has a character date and as I need to compare only parts of it I want to use substring. The below script runs, but it doesn´t get me the correct result as all appears to be different (which is not the case). Am I using Char wrong? If( Subst...
JulieSAppel

Discussions |
Feb 7, 2023 4:58 AM

4252 views | 8 replies
formula not automatically evaluated until clicking apply button

Hello. I made a script adding a column with a conditional formula , the output resulted to a null column only until you click apply in the column formula, I want to automatically output it , I asked colleague to try my data and script , it worked with them. what could be the problem with my jmp16.new column("Remarks01",character,nominal,formula(If( :Remarsk00 == "Y", "1_a", "2_b" )));
sos012523

Discussions |
Feb 6, 2023 11:57 PM

1576 views | 2 replies
Substituting a space for underscore in a character string

Hi:

I have a long description of a product that includes a bunch of underscores __ which I don't want. I'd like to replace them with spaces instead.

I've tried using substr(substitute(columnname, "_",""),1, 999) but that just makes the entire field blank.
I've also tried the reverse (substitute(substr....) same problem. Help!

JMP 17 FWIW.
RandomMapsFox62

Discussions |
Feb 6, 2023 11:43 AM

2911 views | 2 replies
How to perform capability analysis on data that is the same

Hi everyone. I'm trying to run a capability analysis on some sets of data (n=30) where the values do not vary. As far as I am aware, this is not possible. Do I need to treat those sets of data as attribute? Please advise. Thank you!
BBucklen

Discussions |
Feb 6, 2023 9:45 AM

2524 views | 4 replies

Previous
Next

Latest Discussions

Counting and Using Row Identifier

Hello All,

Wanted to ask a question regarding counting of rows. I am attaching a data table which should hopefully illustrate the example.

So I have data where the main variable is density of features. There is a unique value of the density per each ROI, per each sample (ID). In the normalized variable I am taking each density value per each ROI per each sample with unique ID and dividing by the wh...
Ekarshalev

Discussions |
Feb 7, 2023 8:58 AM

4963 views | 7 replies
How to perform capability analysis on data that is the same

Hi everyone. I'm trying to run a capability analysis on some sets of data (n=30) where the values do not vary. As far as I am aware, this is not possible. Do I need to treat those sets of data as attribute? Please advise. Thank you!
BBucklen

Discussions |
Feb 6, 2023 9:45 AM

2524 views | 4 replies
Unresolved Column at Row 1 Error

Hello, I am new to JMP and have been tasked with generating a control chart. One of the tasks for this is to write scripts that will exclude certain values etc. My issue is a little strange and I can't seem to find a fix for it even after scanning this discussion page. Basically, everytime I go to run my script (attached below) I am met with the error 'Unresolved Column at Row 1'. However, if I o...
BenWard

Discussions |
Jan 31, 2023 4:05 AM

2074 views | 2 replies
Standardizing Chart Displays Across the BY role

Hi Everyone, I'm currently using the control chart builder to produce X-Bar S Charts of measurements from a final control system. I've created something I quite like. So I have a Box plot of the measurement for each of the test machines. Quite useful for answering the question "Is there a problem with the test machine or the product being tested?". The problem I have is that I have each the var...
peterrow

Discussions |
Jan 30, 2023 4:56 AM

2123 views | 5 replies
How do I plot multiple XY Series in one graph?

Dragging and dropping x and y values for multiple series data sets gives the following graphI want to see only SeriesA Y vs SeriesA X,SeriesB Y vs SeriesB XSeriesC Y vs SeriesC X

I do not want to see the curves for SeriesA Y vs SeriesB X etc...In excel i am able to do it by selecting the appropriate X and Y values. Can you please help with this plotting?
DualGrizzly1028

Discussions |
Jan 27, 2023 10:03 AM

9009 views | 4 replies

Previous
Next

Latest Discussions

JMP Script Window - Hovering over a variable do not show the value stored in the variable if passed between scripts

I have found that hovering over a variable is very useful feature in JMP Script Window/Editor when debugging the script. I have been working with very long script which I have divided to smaller pieces by using Include-feature. I am able to pass variable content correctly between the included scripts but it looks like hovering do not work on included script windows (showing empty variable content ...
JanneI

Discussions |
Jan 27, 2023 5:51 AM

903 views | 0 replies
Data puzzles via Hanukkah of Data is underway

If you're looking for some data wrangling puzzles, the Hanukkah of Data series of daily puzzles is underway at https://hanukkah.bluebird.sh/5783/. They're on day 2 of 8 now. As far as I can tell, you can do them whenever and there's no competitive part. I'm doing them in JMP, of course!
XanGregg

Discussions |
Dec 19, 2022 11:21 AM

949 views | 0 replies
Slope and Intercept Collector error "matrix must be non-singular in access or evaluation of 'Inv' , Inv/*###*/(x` * x)"

HI all,I have a question about an error I'm getting when using @stan_koprowski's slope and intercept add-in. I've posted my question on the add-in's thread but due to the much lower exposure compared to discussion posts, I thought that it might be a good idea to ask here as well. I made a mock data table with three groups and several observations in each group. When I run the add-in I am getting t...
Lavik17

Discussions |
Dec 19, 2022 10:20 AM

1069 views | 0 replies
JMP 17 Trial - windows server not supported

Dear members of the forum, I have just came across this issue during an attempt to install JMP 17 trial version on a windows server. Any ideas? Edit: I contacted JMP support and they confirm that the trial version will not work on windows server.
ron_horne

Discussions |
Nov 1, 2022 2:20 PM

1361 views | 0 replies
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

705 views | 0 replies