JMP User Community

Latest Discussions

Update a List Box Based on a Combo Box Selection

Hello all, So I have a few lists, in this case fruit and vegetables, and based on my selection on the combo box I would like to populate the list box with the new list. For example, if I have "fruit" selected, I want the list box to display oranges, apples, and grapes. The script I have works, but it doesnt evaluate the list AND I also do not want it to keep appending the list box with my selectio...
Ksrzg01

Discussions |
Apr 5, 2018 10:03 AM

7459 views | 4 replies
Hiding rows in data table view

When a Cols > Hide is chosen, the column collpases and is no longer visible in the table view.When Rows > Hide is chosen, the row gets a row state icon of [mask], but the row is still visible in table view.I know that hiding rows is more about hiding their data in *plots*, but still…is there a way to not show hidden rows in the table view?
john_madden

Discussions |
Apr 5, 2018 9:06 AM

7735 views | 1 replies
Conditional Pass/Fail based on limit

Hi guys, Similar to one of previous posts, I have the following problem as shown as below: In this case, if any of the result is >=15 in at least two sub_rad then it is consider Fail otherwise will be regarded as a Pass(as shown in the Pass_Fail col). Currently I'm using Formula but only know how to do it in a single sub_rad. Kindly suggest how can I do it with a script or formula. Thank you. IDte...
adam

Discussions |
Apr 4, 2018 10:44 PM

6732 views | 3 replies
End Of Field(other)

I have a file (essentially a text file but with .log as the extension). It is comma seperated. Contains both character and numeric data. Every now and then I get a ID number with a comma in it. This throws the columns off. looking at the data I see that all the values I want to seperaate actually have a space after the comma. I want to seperate the columns with something like this: For( i =...
KST-CPT

Discussions |
Apr 4, 2018 4:28 PM

5894 views | 2 replies
Min and Max values of all numeric columns

I am trying to extract minimum and maximum values from all numeric columns of a table. However, I also want the column name of which the values are extracted. Here is my script:dt = Open("Path");
nc = N Row(dt);
mycol = dt << get column names;
//show(mycol);
for(i=1,i<=nc,i++,
If( x = Column( dt, i ) << get data type() == "Numeric",
myMax = col max(column(dt,i));
print("Max:",myMax);
myMin = col min(colum...
powerpuff

Discussions |
Apr 4, 2018 2:55 PM

10202 views | 3 replies

Previous
Next

Latest Discussions

Col Mean behaviour with hide/exclude

Hello, I observe that when I use ColMean function in one column that the value in the column is not updated when I hide/exclude some rows.I think this is not a normal behaviour - there is no automatic recalculation. May be we can avoid this with script but I would prefer to avoid. If someone has a solution, thank you in advance Regards Sébastien
seb38360

Discussions |
Apr 4, 2018 11:50 AM

2981 views | 1 replies
Multivariate results interpretation

Hi JMP experts! I have a question about how to interpret multivariate results: say I have a data set y, x1, x2 three colums. I try to answer the question whether y is correlated with x1, or x2 or both. I have got Rsquares values and correlation probability both in 3 by 3 matrix form from JMP. The question is whether should I use the probability value to answer the question, or should I use the Rs...
JMPstart

Discussions |
Apr 4, 2018 5:41 AM

7474 views | 4 replies
How to hide x-variables with no data when Overlay with Boxplot for Legend.

Hi all, I have two levels in x-axis and i am trying to color legend my boxplot using the first level. The only way i found that can do that is using Overlay but the boxplots would be distorted because each distinct grouping will be split into n areas of level 1. For better illustration, i am using Animals.jmp as examplex-axis 1st level - Speciesx-axis 2nd level - subjecty-axis - miles Graph below ...
cchiat

Discussions |
Apr 3, 2018 6:02 PM

3348 views | 2 replies
Validation and weighting

I'm working with a file of approximately 8500 records where approxmately 100 have a resonse variable value Y and the rest a value of N. I'm running a Partition Model on the response variable Y and then adding in various X, Factors. Given the relatively low number of "responses" I have two questions when using this model.1) shoud I weight the resonse variables using conditional formatting (adding...
tallman

Discussions |
Apr 3, 2018 2:12 PM

6632 views | 9 replies
(individual-specific) Status Quo Option? - Discrete Choice experiment

Hi, I am a fresh community member. I can't find a fundamental information for my design in the documentation (unless I use wrong wording). My discrete choice experiment (DCE) is about analyzing preferences of car-sharing users and non-users. The important point is the status quo option (important in DCE) which depends on your initial transport mode (e.g. bike, public transport, private car, etc)....
RiMaDoN

Discussions |
Apr 3, 2018 4:58 AM

3007 views | 2 replies

Previous
Next

Latest Discussions

P value, L-R Chi Square, Prob Chi Square in Choice results

Hello everybodyI am going to undrestand the P value, L-R Chi Square, Prob Chi Square in Choice results. But different interpretations of these values can be found in the web. It seems that the true interpretation is related to null hypothesis and confidence intervel.The results of the study are as the attached pictures.Could any body inform me what exactly these statistics are saying and base on w...
aryasohrabi

Discussions |
Mar 17, 2018 2:22 AM

4005 views | 0 replies
Convert separate DATE and TIME columns in formats YYYYMMDD and HHMMSS into a single column

Hello, I manage an addin for my company where all data is imported into JMP via command line utilities owned by our automation team. My addin translates a users request into a formatted command and issues the command in the background. The data is returned back as a text file on the users system. My addin can then load the data from the text file. The issue that I have is that the columns vary bas...
Picard

Discussions |
Mar 15, 2018 1:57 PM

2808 views | 0 replies
pseudo r square in JMP choice model platform

Hi,I am using JMP's choice model platform to analyse some Discrete Choice Experiment (DCE) data. I am trying to find the pseudo r square but the platform does not provide it. Is there a way to calculate pseudo r square based on the results JMP presents under the choice model platform? I know pseudo R square comes up as entropy RSquare under JMP's fit model platform, nominal logistic fir for respon...
DG

Discussions |
Mar 11, 2018 6:27 AM

2414 views | 0 replies
chnging colors on PCA plot

Hi,I seem to be able to change the color of the circle around the PCA plot but not the arrows which remain red no matter what I do. I changed the circle by Right Clicking on the plot --> Customize --> Circle and selecting the black color. I did the same using the option of Customize --> Arrow but nothing changes.Any advice would be appreciated.Thanks a lot.Helga
helga55

Discussions |
Mar 9, 2018 2:20 PM

3758 views | 0 replies
.jsl scripts will lock files even while set to read and execute permissions only

I am having an issue where an add-in script which runs another script via the include(); function is locking the included script file while other users are running it. This renders me unable to update that script. I tried setting the permissions on the repository and the file as read and execute only but it still locks when other users access it.
nbullen

Discussions |
Feb 5, 2018 12:05 PM

2478 views | 0 replies