JMP User Community

Latest Discussions

How do I update from database without overwriting hide and exclude values in datatable.

Hi, brand new to JMP. I set up an ODBC connection to my database and I am able to pull in data. I pull in the last 60 days worth of data. I can go through and exclude or hide data as necessary. When I run the Update from Database script I created all of the rows that I excluded or hid are now back to include and unhid. I have users who will be refreshing and running control charts daily. I don't w...
Zero_Cool

Discussions |
May 30, 2017 8:15 AM

9533 views | 3 replies
how to replace empty values of numeric columns with the average column value

good morning,someone can help me? ...i would like to replace empty values of numeric columns with the average column value. i tried this dt = Current Data Table();FILL = dt << get column names( Numeric );For( i = 1, i <= N Items( FILL ), i++,FILL[i][dt << get rows where( Is Missing( FILL[i][] ) )] = col mean(FILL[i]);); thanks in advanceGianpaolo
gianpaolo

Discussions |
May 30, 2017 5:39 AM

10018 views | 3 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

6493 views | 3 replies
Problem with Parameter Estimates in a Regression Interaction

Hello! I am having difficulty looking into what drives an interaction I have found. The interaction is between Age and Group. Since Age is a continuous variable, I have used a regression to look into it. I would like to do individual t-tests within the regression to see what is driving the interaction. I believe this would be under the "Parameter Estimates" section of the report. However, for what...
jstrut

Discussions |
May 28, 2017 11:35 AM

8639 views | 2 replies
How to loop generate graph for all columns

Hi, Everyone I trying to get my first loop work, but stuck with one issue. It simply gets all cloumns, and loop through and plot all columns. The problem is in test == ( y_cols[i] ) ;My intension is test is the individual columns name, but when i debug, it seems test is a list of all columns, same as the y_cols. So when i run the script, it plots only the first column, many times. dt = Cur...
Jay

Discussions |
May 27, 2017 7:12 PM

7116 views | 2 replies

Previous
Next

Latest Discussions

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

6493 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

7520 views | 2 replies
How do I test the parallel lines assumption when doing ordinal regression in JMP?

It can be done in SAS but I can't find that this is available in JMP and it is not clear to me how to edit the ordinal regression script in JMP to get the results I need.
dherring_wakehe

Discussions |
May 26, 2017 6:47 AM

13683 views | 5 replies
List Boxes; customizing # of plots per row

Hello,When using the following script, the window will produce a single column of plots.pltx=dtnm<<(Bivariate(Y( :Name( "|id|" ),:Name( "|ib|" ), :Name( "|ig|" )),X( :vg ),By( :device, :tdegc, :wid, :len, :str, :vd, :vb ))); I am interested in knowing of methods to produce a window that has the three dependent variables in side by side fashion for the given 'By' variables, and with the next row in...
johnm

Discussions |
May 25, 2017 1:06 PM

5952 views | 4 replies
Change Font size of axis in Mosaic plot

Hi I am trying to make a Mosaic plot representing the sales of different products across different regions. I am using a Mosaic plot in Fit X by Y, but I cannot change the font size of the horisontal axis (regions in the attached table and pictures below). Alternatively, I can build the same plot using graph builder, but then I cannot add the labels to the plot (A, B, C, etc). Can anyone help me? ...
thomas_steen_ha

Discussions |
May 24, 2017 3:09 AM

4329 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

2279 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

4525 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

3426 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

3539 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

4527 views | 0 replies