JMP User Community

Latest Discussions

Scripting column switcher using variable

I am scripting a dashboard with graph builder in it. I want to add a column switcher that should use a variable as a column list, due to changing columns. For some reason this doesn't work, only first column in a list will show. Column list is created like this: col_list3 = dt << get column names(Numeric); for (i = nitems(col_list3), i > 0, i--, if (!contains(col_list3[i], "%"), remove from(col...
mes

Discussions |
Jan 22, 2021 8:23 AM

5614 views | 5 replies
Fit least square ==> asking for control level.

Hi, I wrote below script (simple fit least square but the effects are categorical) and it worked fine on my system (JMP 15.1). When my college try this script on his computer (JMP 15.0). When he ran this script, it showed pop up menu asking for control level - see picture.I manually plotted the least square on his computer and it showed the same message - asking for control level.If I clicked canc...
yanee

Discussions |
Jan 22, 2021 7:20 AM

1219 views | 1 replies
Font colour changes when spinning a surface plot

I've produced a surface plot using a predicted formula from a definitive screening design. I'd like to present my plot in a presentation with the plot rotating. To do so I followed this thread: https://community.jmp.com/t5/Discussions/Spinning-a-Scatterplot-3D/td-p/6510 The advice here was originally for a scatter plot, however I got it working using the same line of code:Set Spin( 0.01, 0, 0.01, ...
macca5019

Discussions |
Jan 22, 2021 6:22 AM

1781 views | 3 replies
k-fold cross-validation with stepwise regression_R Squares for training and validation

Hi, I have a problem when doing k-fold cross-validation with stepwise regression: I want to run the k-fold cross-validation with stepwise regression for 100 times using same dataset and save the R squares for both the training and the validation sets. The results table of JMP include two columns, “RSquare” and “RSquare K-Fold”. Although I can get different “RSquare K-Fold”, it seems that e...
Adele

Discussions |
Jan 21, 2021 2:59 PM

4620 views | 2 replies
Response Screening - Multiple model effects?

I am trying to analyze a medium / large proteomics dataset (3350 proteins) using the response screening analysis. The problem is that I have multiple model effects to take into consideration - I have treatment vs control, but I also have samples from multiple days to consider, but I clearly can't run this as a fit model. Is it possible to take both treatment and day into consideration using JMP...
Sloux

Discussions |
Jan 21, 2021 10:47 AM

2271 views | 3 replies

Previous
Next

Latest Discussions

Font colour changes when spinning a surface plot

I've produced a surface plot using a predicted formula from a definitive screening design. I'd like to present my plot in a presentation with the plot rotating. To do so I followed this thread: https://community.jmp.com/t5/Discussions/Spinning-a-Scatterplot-3D/td-p/6510 The advice here was originally for a scatter plot, however I got it working using the same line of code:Set Spin( 0.01, 0, 0.01, ...
macca5019

Discussions |
Jan 22, 2021 6:22 AM

1781 views | 3 replies
Response Screening - Multiple model effects?

I am trying to analyze a medium / large proteomics dataset (3350 proteins) using the response screening analysis. The problem is that I have multiple model effects to take into consideration - I have treatment vs control, but I also have samples from multiple days to consider, but I clearly can't run this as a fit model. Is it possible to take both treatment and day into consideration using JMP...
Sloux

Discussions |
Jan 21, 2021 10:47 AM

2271 views | 3 replies
Xbar control chart and labeling the average UCL, LCL

I want to find a way to label the average and control limits on the control chart. for the sake of clear reporting, It would be great if the data mean was labeled right on the chart field or on the axis. of course, the limit summary is displayed to the right, but I need it to show up inside the graph. I could manually add the data label on the axis but it would be great if i could just toggle it a...
tatersalad

Discussions |
Jan 21, 2021 10:32 AM

1829 views | 2 replies
Extracting a number from a text field

I have a column containing text notes entered by technicians. They enter the system usage hours, which I need to extract into it's own column. Fortunately, the data is pretty consistent, and so I have been able to pull the info out using Regex Match(), but selecting the last value is tripping me up.Regex Match( :diagnosis, "(ys.+sage: ?)(\d{1,5})\n" );How do I extract the System Usage hours from t...
robressler

Discussions |
Jan 20, 2021 1:29 PM

1156 views | 2 replies
saving script to data table issue

HI all, I have written a script (a few hundred lines) that 1) opens an existing data table, 2) does a whole bunch of calculations and then 3) spits out a new data table with results from these calculations. Because I am continually improving the script, I want to make sure that I know which exact version of the script was used to create the new output data table and so thought of saving the whole...
yvesprairie

Discussions |
Jan 19, 2021 7:11 PM

2421 views | 6 replies

Previous
Next

Latest Discussions

Tablebox <

Using JMP 12.x, I noticed that: tablebox() <<sort by column does sort the column fine, but it does not seem to preserve any existing cell coloring post row sort. Is there any way to force it to preserve the existing cell colors post row sorting?
thanks, DJ
djhanson

Discussions |
Jan 14, 2021 9:17 AM

1294 views | 0 replies
Comparing observed/predicted from different models. (Mean Absolute Deviation (MAD) or Mean Absolute Error (MAE))?

I'm using the neural platform to calculate a model that makes predictions from some observed data and want to compare the performance of that model to other models (not from JMP). To compare the different models, I want to compare the observed data and the predictions from the different models.The R2 is not a good measure because it checks for any linear relationship between the observed and predi...
matthias_bruchh

Discussions |
Jan 8, 2021 2:32 AM

3710 views | 0 replies
Graph Builder - Remove Combine Scales?

In graph builder I am interested in plotting a simple Y vs X for multiple X variables. By default graph builder combines all the different X variables on the same X axis and scale. Is there a simple way to change the X axis to have separate scales on the X axis for each variable? Default graph builder (script1, graph1)Plot 1 variable on Y axis vs 8 variables on X axisAll 8 variables on same x-axis...
ehorne

Discussions |
Oct 29, 2020 9:11 AM

1559 views | 0 replies
SharePoint Online

My company recently began the migration from SharePoint 2010 to SharePoint Online. I have found that my JSL scripts are now no longer able to open or save files to the new SPO site. Anyone have the correct updated syntax for this. Example 1 (SP 2010): This worked. TablePath4 = "\\sharepoint.amr.ith.company.com@ssl\sites\rpt\documents\JMP_tables\"; //set variable TablePath path location Tabl...
Outdoorsman1963

Discussions |
Oct 23, 2020 4:06 PM

1347 views | 0 replies
How to run a Post hoc for Chi Square results in JMP?

I was wondering if someone can help me. I want to run a post hoc analysis for the chi square results in JMP. Thanks
vmendez17

Discussions |
Oct 22, 2020 7:33 PM

846 views | 0 replies