JMP User Community

Latest Discussions

calculate area under the curve by integration then populate the result in a new column.

In this example datatable, response is defined by fomula: response = time*timeI would like to calculate "area under the curve" (AUC) by integration using the fomula defined in the response column and the time range defined in the :time column, then populate the result in a new column in the datatable (by "populate" I mean all rows have the value of the calculated AUC). I know I can use the follow...
GroupSquareWolf

Discussions |
Mar 21, 2023 11:34 PM

2712 views | 3 replies
Data filter for drop down box

Hi, all. There might be similar questions here, but I didn't find one that solves my problem.On the dashboard, I made inputs into a drop down box. i want the output table to change when I select different inputs. What functions should I use and is there a sample somewhere?Thank you so much!
OrthogonalCrow3

Discussions |
Mar 21, 2023 7:22 PM

940 views | 1 replies
How to solve the error "append to first table" in JMP version 17?

Using the following command in JMP version 17, the last column of the second table becomes a missing value.dt << Concatenate( Data Table( "Trial2" ),append to first table );Using JMP15 there is no such problemmissing values
lehaofeng

Discussions |
Mar 21, 2023 5:32 PM

1254 views | 2 replies
Functional Data Analysis and Classification: How to calculate FPC of new data (unseen by the original fit) using initial model's Fourier basis?

Hi! I am running an experiment using several sensors out of a laboratory experiment where I've been able to collect about 700 samples , each with about 200 points of functional data, I've been using Functional Data Explorer for dimensional reduction through fitting of a Fourier basis and then its corresponding FPCs. I am following the example " Fermentation Process" example found in documentation ...
RiztCL

Discussions |
Mar 21, 2023 2:53 PM

2450 views | 4 replies
Regex: computation speed & incomplete formula run

Hello, I have two questions about regex.Below I've shown some code. I'm creating formula columns that parse information from another column. The formulas grab the correct information, but ALWAYS stop at row 3024. The datasets I work with can be tens or rows, or much larger.
dt << New column( "Column 1", formula( regex( :Other column, "pattern" ) ) ); dt << New column( "Column 2", formula( regex( :O...
StarfruitBob

Discussions |
Mar 21, 2023 10:54 AM

1703 views | 4 replies

Previous
Next

Latest Discussions

Data filter for drop down box

Hi, all. There might be similar questions here, but I didn't find one that solves my problem.On the dashboard, I made inputs into a drop down box. i want the output table to change when I select different inputs. What functions should I use and is there a sample somewhere?Thank you so much!
OrthogonalCrow3

Discussions |
Mar 21, 2023 7:22 PM

940 views | 1 replies
Longitudinal multinomial mixed-effect models

Is it possible to do longitudinal multinomial mixed-effect models in JMP?
ChristerMalm

Discussions |
Mar 21, 2023 8:09 AM

726 views | 1 replies
JMP > Proportional Hazard with Continuous parameter > Cutoff Optimization

Hi JMP Community, JMP 16.1 Standard Windows This might be a naive question. I am exploring the impact of a continuous baseline variable on the survival of subjects using the Proportional Hazard platform. I identified some factors with strong associations (see one example below), but I am still determining how to visualize this relationship. For example, I can create a survival plot if I crea...
Thierry_S

Discussions |
Mar 21, 2023 6:50 AM

1594 views | 3 replies
Margin of error of predictor screening

Hi!I was wondering if I can get the margin of error of a predictor screening model I run to be able to compare the portion of the predictors across different groups within one sample -by running the model "By" the different groups- and understand if the differences are true differences or not -similarly to the concept of statistically significant differences in research/ survey data-.Does this mak...
melina_d

Discussions |
Mar 21, 2023 4:41 AM

1275 views | 2 replies
Import file issue

Hello,I am having issues importing my excel file into JMP.When in JMP, I click on file, then open, and when my file explorer opens, none of my excel files are shown in my file explorer.How do I get my excel files to show up in my file explorer so I can select them to be opened in JMP?
Blakezu

Discussions |
Mar 21, 2023 4:40 AM

1063 views | 2 replies

Previous
Next

Latest Discussions

Black Cursor Keeps Turning into the Regular Windows Cursor

I am trying to hover over values to get the provided explanations, but it won't work because my mouse cursor keep changing into the regular white windows cursor. I only have the black cursor when hovering over certain things (like graphs) but I want it to be active for the entire window. Is there anyway to fix this? Edit: Nevermind, the white cursor works fine. I saw in another discussion that I j...
Shipidento

Discussions |
Mar 17, 2023 5:50 PM

1351 views | 0 replies
problème affichage date et heure dans un dashboard

bonjour, j'ai créé un dashboard avec un script. Quand je fais affiché la date et l'heure, j'ai des affichages qui varient et qui décalent mes graphiques.comment je peux supprimer ce problème dans mon script? cordialement
Françoise

Discussions |
Mar 17, 2023 4:55 AM

984 views | 0 replies
JMP17 JSL 读取多张表时值为空怎么解决？

JMP17版本用之前15版正常的读取程序，结果为空值。比如第一个表中一行是1,2,3这种值的，第二张表这一系列，是这列，ML1,R1拼接在一起，L1,R1,M1就自动改变亏值。求问大佬怎么解决？dir = Pick Directory( "Select a directory" ); //得到所有文件名，注意要确保所有表格字段名一致，且表格样式一样，否则会得到非预期结果。 files = Files In Directory( dir, Recursive ); If( Contains( files, ".DS_Store" ), files = Remove( files, Contains( files, ".DS_Store" ) ) ); For( i = 1, i <= N Items( files ), i++, fullfile = dir || files[i];...
lehaofeng

Discussions |
Mar 16, 2023 5:58 AM

698 views | 0 replies
How to get ROC table for Neural Network classification model?

I fitted Neural Network on a dataset that has nominal response variable. For logistic regression model, I can see ROC table along with ROC curve. However, in neural networks (and other ML models) I only get the ROC curve but not ROC table.
abhinavsharma91

Discussions |
Mar 12, 2023 5:58 AM

683 views | 0 replies
change font size only on the major ticks when using log scale

Hi, when using a log scale two font sizes are being used (for the major and minor ticks). How do I only change one of them (e.g. major ticks)? Any change I make seems to apply to both. In other words, I want to have the font size for 100, 1000 to be closer to that of 200, 300, 400 in the example below using JMP17.0.0
mvanderaa1

Discussions |
Mar 10, 2023 3:07 AM

715 views | 0 replies