How to get "AND" in filter in sql query builder with JMP14
Hi, with the sql query builder, we can add several filters like the picture below. We have always "OR" with the filters. Could it be possible to have "AND" instead of "OR"?
Find courses, tutorials, and lots of other methods of learning JMP.
view all learning resourcesHi, with the sql query builder, we can add several filters like the picture below. We have always "OR" with the filters. Could it be possible to have "AND" instead of "OR"?
Dear all, I will first of all try to introduce with an example the problem I am facing. Imagine a table with 100 lines and 6 columns (PAR1, PAR2, VAR, MOD, MEA, ERR).The column MOD contains a model (=a formula) that depends on 3 parameters P1, P2 and VAR.The values of the columns P1 and P2 are fixed and different for each lines.The column VAR contains the third parameters, which is initialized at ...
HiAfter running a linear regression using the Fit Model platform, JMP displays P value (as P), RSq and RMSE on the bottom of the a Actual by Predicted Plot. I would like to understand how P value is calculated and what it means.I ask this because in a simple Y =aX+b case, the p value is identical to the p value of the X but if there are more Xs (e.g. Y = aX1+ bX2 + c) then, p value is something el...
How can I identify which rows(observations) are my validation points when my target variable is category variable when I use random selections? such as example from https://www.jmp.com/support/help/14/example-of-profit-matrix-and-decision-matrix-rep.shtml#1276835 I know for continuous target variable, I could select rows from predict vs actual plot to know which observations are labeled as validat...
Hi, I collected data on the monthly occurrence of a parasite and the monthly occurrence of a histological lesion in the tissues where the parasite infects. The parasite is strongly seasonal - peak prevalence and intensities occur in March and April. The lesions are more spread out throughout the year but appear to be more common in those months. So for each (lesion or parasite), I can construct...
HiAfter running a linear regression using the Fit Model platform, JMP displays P value (as P), RSq and RMSE on the bottom of the a Actual by Predicted Plot. I would like to understand how P value is calculated and what it means.I ask this because in a simple Y =aX+b case, the p value is identical to the p value of the X but if there are more Xs (e.g. Y = aX1+ bX2 + c) then, p value is something el...
Hi, I collected data on the monthly occurrence of a parasite and the monthly occurrence of a histological lesion in the tissues where the parasite infects. The parasite is strongly seasonal - peak prevalence and intensities occur in March and April. The lesions are more spread out throughout the year but appear to be more common in those months. So for each (lesion or parasite), I can construct...
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
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...
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 ...
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...
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...
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...
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
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.
Jump into Graphing Date: Tuesday, September 16Time: 1:00 – 2:30 p.m. ETDuration:&nbs...
Elaborate on Elaborate: Advanced Interactive Reporting & AI-Enhanced Development In this...
Una introducción práctica para nuevos usuarios, usuarios con licencia de prueba o cualquier persona...
REGISTER HERE *** Note that this webinar starts at a different time than the other Fall 2025...