JMP User Community

Latest Discussions

Column Formula, Relative Value Calculations

I have been trying to script a new column formula for a data table, where the calculated value changes based on values of columns to the left. Example of what I mean using the "Big Class" example file. Let's say there are 200 rows as opposed to 20, each name appearing 10 times in succession as though the heights and wieghts were recoreded once a year for ten years, additionally there would be ano...
FaxMachine

Discussions |
Jun 6, 2017 11:59 AM

9200 views | 7 replies
Status of Query running in the Foreground

Is it possible to update the user on the status of a query running in the foreground using JSL? I have a SQL query that takes hours to run and the script needs to operate on the table after it opens so I cannot run it as a background query. Currently I am using Open Database():/* fictitious database and table */ dt = Open Database( "DSN=ODBC Connection", "SELECT * FROM some_table" )
ih

Discussions |
Jun 6, 2017 5:45 AM

11840 views | 5 replies
get rows where and select where

I'm seeing a weird issue with get rows where when trying to make it dynamic.dt = Open("$SAMPLE_DATA\Big Class.jmp");dt << get rows Where(:Sex == "F"); //Worksdt << Get Rows Where(Column("Sex") == "F"); // Doesn't Work//but ... col = :Sex; //doesn't workcol = Column("Sex"); //Works//so trying to do dt << Get Rows Where (col == "F");//can't work in any way that I can see
Tried a few different version...
vince_faller

Discussions |
Jun 5, 2017 9:02 PM

16784 views | 5 replies
Create a RSM using already collected historical data

Hi, I have a dump of historical values for the explanatory and response variables. How do i build an RSM given this data? Can i build a custom design based on data already collected for a series of runs?
soumyar

Discussions |
Jun 5, 2017 10:07 AM

8851 views | 6 replies
How to change colours of points in box plot

Hi I want to change the color of my data points in box plot. By default it is showing in black color.
omer89

Discussions |
Jun 5, 2017 6:38 AM

10579 views | 2 replies

Previous
Next

Latest Discussions

Function for back button

Hi, everyoneI can create a button named as "Back". But may I know is there any function that can back to the previous interface when i click the back button?
Thanks.
jade

Discussions |
Jun 2, 2017 4:50 AM

3652 views | 2 replies
Parallel Processing in Scripting

In the process of putting togother a lengthy script that makes some calls to ODBC/SQL databases that can each take several minutes to run. In an ideal world I could be waiting for multiple servers to get back to me at the same time. From what I am gathering I have to stick with just running one database request after another?I am running JMP 9.
firemandan9

Discussions |
May 31, 2017 12:46 PM

7004 views | 4 replies
Disabling all or individual check boxes not able to be re-enabled with opposite method

I have two sets of check boxes and one is being used to control which options are enabled on the other. I seem to have run into an issue using Enable and Enable Item. If I have previously disabled all the checkboxes I am unable to enable them individually unless I enable them all first. Conversly, if I disable individual check boxes, it appears I am unable to enable them all at once. As it is curr...
SG

Discussions |
May 30, 2017 12:14 PM

3765 views | 1 replies
how to change the range of this graph ?

i am attaching a image of the graph, in this graph if you can see on the y-axis all the ranges are from 015 to 15. But if you can see only C15 label has higher value than 15 but the other labels are less than 5 for C14 and C16. So how can i change the values of C14 and C16 to lesser values like 8 in this case for C14 and 5 for C15. Plz share your opinion. Also the values are much coarser i.e +15 ...
Drharsha

Discussions |
May 28, 2017 3:58 PM

6503 views | 3 replies
apply my PLS model to new data

Hey all, I am using Partial Least Squares (PLS) analysis to find a model to predict concentration of sustance from spectral data - which means I have 6800 variables.After tweaking the data, resampling, tweaking some more and other things I seem to have found a predictive model that I can trust. My question isHow can I apply this model to new data? even one sample at a time. Thanks!Amir PS - Using ...
anakar

Discussions |
May 26, 2017 11:54 AM

7535 views | 2 replies

Previous
Next

Latest Discussions

Printing worksheet with cell colors

Hello JMP Community, I'm currently using JMP version 10.0.0 and having trouble printing my data table with cells highlighted in certain colors. Is there a way to print keeping the colors or to even export the file keeping the cells highlighted?

Thanks.
ferdt58

Discussions |
May 16, 2017 9:14 AM

2291 views | 0 replies
Linearity and Bias Report

In Our MSA stsudy we are performing Linearity and Bias measurment. We are currently controlling at Linearity and Bias to be below 5%. We actually generate the following report for Linearity and BIas. However in AIAG handbook the criteria for the gauge to pass bias criteria has the following criteria.
Aravindan

Discussions |
Apr 18, 2017 12:54 AM

4543 views | 0 replies
CCC Optimal

Hi,I have 2 clustering chooses as mentionned below,- Nr of cluster 15 : CCC = 69.99 (OPTIMAL)- Nr of cluster 15 : CCC = -92.87- Nr of cluster 15 : CCC = -112.8 The first one with CCC = 69.99 is mentionned as the best optimal. I don't understand why this one is the best by consedering the different values ?. What is the signification of these values ? Thanks,
Lamine

Discussions |
Mar 17, 2017 5:25 AM

3431 views | 0 replies
Understanding the Dispatch and Legend Model and what exactly is Base(0,0,0)?

My problem is two fold. Im writing a JSL Function to create some custom charts at work. Everything is working fine. Thats great. But I dont understand why - and I am trying to break down the code. Most of I wrote myself, but some aspects I made the tweaks within JMP, copied the scripts and used the parts that generated what I needed. Some of the code chunks that get added in are intuitive to read ...
kevinwtbolger

Discussions |
Feb 26, 2017 9:30 AM

3549 views | 0 replies
Data Binding Associative Arrays

I recently had need to create some slightly complex data structures and started to play with associative arrays a little more. These are similar to dictionaries in other languages. Where they differ is that most languages to improve speed, when assigning an object in a dictionary to a variable it does a data binding. Essentially it makes it so both the dictionary and the variable refer to the s...
msharp

Discussions |
Feb 14, 2017 1:53 PM

4542 views | 0 replies