JMP User Community

Latest Discussions

Tutorial for building 1-click dashboards

Does anyone know of good tutorials for how to build interactive 1-click dashboard using JSL? For example, I would like to build a user interface which allows the user to select an item from a dropdown list and display some sort of visualization charts based on the user selection. Thanks,Simon
simon_2

Discussions |
Mar 19, 2021 1:03 PM

2800 views | 2 replies
Transposing from WIDE to LONG and a formula question

Hi--two somewhat related questionsI have used SPLIT to transform a long file to a wide file, but I have a slightly more complicated situation where I want to STACK/transpose a wide file to a long file. I have a dataset with a unique subject ID, and then several hundred columns/variables. The variable names are the exact same with the exception that Year 1 ends '2', Year 2 ends in '3', etc. Is ther...
plfazeli

Discussions |
Mar 19, 2021 8:16 AM

2465 views | 3 replies
CMD window for logging never shows up while using RunProgram

I got an issue while using "RunProgram" to call my exe, a CMD window for logging is supposed to appear, but it never shows up. The CMD window can normally pop up when I manually run it. Is there anyone who can help me solve the issue? Thanks in advance : ) JSL code: RP = Run Program( Executable( exefilepathRoot || "CommonalityEngine\PyScript\get_data_from_cache.exe" ), Opti...
baiyun

Discussions |
Mar 19, 2021 6:54 AM

2504 views | 4 replies
Fill in Missing Data Based on previous column [cell] value

I apologize for this redundant question about column fill but for the life of me i can't find any of the previous topics. I have a data table that is filled out in an incomplete manner. I need to fill the missing cells below each value with its predecessor. I know it is a Column Formula script that uses the Lag() and Row() but can't find the correct syntax.
Yngeinstn

Discussions |
Mar 19, 2021 6:50 AM

2388 views | 1 replies
Making a Mixture Design that Does Not Sum to 1.0

I am trying to make an I-optimal mixture design with 3 components that add to 0.883, with the remainder 0.117 being a fourth, but constant, ingredient. I know a possible work around is to normalize my constraints, but to avoid confusion in reporting the information I would like to have the three components add to 0.883. I have tried to add linear constraints (shown in the attached screen shot) but...
David_J

Discussions |
Mar 19, 2021 6:49 AM

1975 views | 2 replies

Previous
Next

Latest Discussions

Transposing from WIDE to LONG and a formula question

Hi--two somewhat related questionsI have used SPLIT to transform a long file to a wide file, but I have a slightly more complicated situation where I want to STACK/transpose a wide file to a long file. I have a dataset with a unique subject ID, and then several hundred columns/variables. The variable names are the exact same with the exception that Year 1 ends '2', Year 2 ends in '3', etc. Is ther...
plfazeli

Discussions |
Mar 19, 2021 8:16 AM

2465 views | 3 replies
CMD window for logging never shows up while using RunProgram

I got an issue while using "RunProgram" to call my exe, a CMD window for logging is supposed to appear, but it never shows up. The CMD window can normally pop up when I manually run it. Is there anyone who can help me solve the issue? Thanks in advance : ) JSL code: RP = Run Program( Executable( exefilepathRoot || "CommonalityEngine\PyScript\get_data_from_cache.exe" ), Opti...
baiyun

Discussions |
Mar 19, 2021 6:54 AM

2504 views | 4 replies
why is last menu hierarchy appears on the left not the right?

How can I get screening design appearing to the right in the above?
0465

Discussions |
Mar 19, 2021 5:00 AM

1400 views | 1 replies
about the project

hi, is it possible to modify a part of the screen in the project: see the image.I would like to put some colors and titles. best regards
Françoise

Discussions |
Mar 19, 2021 4:16 AM

1593 views | 3 replies
Filtering Pareto charts by column.

I have a very large dataset of manufacturing defect bin data.My columns are the manufacturing batch IDs (called lots), and then each column is a defect bin, with the numeric value for that particular defect bin for each lot. In JMP Pareto chart, the input needs all defect bins in one column. So, I have to make another table by stacking those defect bins using Table>Stack. This makes an even larger...
spoikayil

Discussions |
Mar 18, 2021 12:53 PM

2165 views | 2 replies

Previous
Next

Latest Discussions

What does it mean when the solution path for Elastic Net is not single-valued?

Dear JMP Community, (W10, 64-bit, JMP Pro 15.2.1) I am running a model to assess the active predictors. I am doing this by using the Autovalidation add-in to generate a Null Factor for my data. I then use the GenReg platform to find estimates for each possible X-factor and then Bootstrap those estimates to get a better assessment of the contributions to the response. I came across a very stran...
SDF1

Discussions |
Feb 15, 2021 12:35 PM

1578 views | 0 replies
Return number from specified row of calculation column in either a text edit box or number edit box in an add in

Hello, I'm attempting to build an application in application builder. I have two modules currently. The first module is a series of number edit boxes and lists that allow the user to input values and make selections.After pushing a button, the inputs and/or list selections update table variables in a data table that subsequently updates column equations. The data table opens in the background so ...
tys5384

Discussions |
Feb 15, 2021 7:33 AM

1386 views | 0 replies
generalized regression

How do I get a whole model significance test when conducting a generalized regression using the negative binomial distribution? I can get the individual effect significance tests, but I do not see where I can get the whole model significance.
Mrubra

Discussions |
Feb 3, 2021 2:31 PM

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

1513 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

4252 views | 0 replies