cancel
Showing results for 
Show  only  | Search instead for 
Did you mean: 
The Discovery Summit 2025 Call for Content is open! Submit an abstract today to present at our premier analytics conference.

Welcome to the JMP User Community!

Ask questions, get answers, meet other JMP users
cancel
Showing results for 
Show  only  | Search instead for 
Did you mean: 

Learning Resources

Latest Discussions

  • Moving average and Weighted moving average on a data set

    Hi, I am trying to do a moving average and a weighted moving average on the data set that I have posted below.I want to do a moving average to the 'Mean' column.Also can I repeat this formula by the 'Sample' group in my data set

    anandk anandk
    Discussions |
    Mar 22, 2017 8:27 AM
    14227 views | 14 replies
  • Keeping colors based on column consistent across graphs

    I'm currently working on a dashboard for a factory production floor. On the one side I'd like to show holes being drilled into the fuselage or the aircraft in a 3D scatterplot. On the other side I'd like to show the start times of each drill job which is basically a scatterplot with some categories on the vertical axis and continuous time on the horizontal axis. There are multiple fuselages in the...

    burakbagdatli burakbagdatli
    Discussions |
    Mar 21, 2017 12:22 PM
    9827 views | 3 replies
  • Heatmap Using Maximum instead of Mean

    Hello Is it possible to create a heatmap using the maximum value at each (x, y) rather than the average? Thanks! 

    aallman aallman
    Discussions |
    Mar 21, 2017 11:45 AM
    5307 views | 1 replies
  • Corresponding Row for a Column Minimum

    I am trying to find a corresponding row for a column Minimum "DEF" and trying to do that by column "GHI"?I am able to find the Column Minimum for "DEF" but I am not getting the corresponding row value for column "ABC"? I am using the following piece of code: dt = current data table();
    dt<<newColumn("BestB",numeric,continuous,Format("Best"),Formula(x = col minimum(:DEF,:GHI);));dt<<newColumn("BestO"...

    anandk anandk
    Discussions |
    Mar 21, 2017 9:42 AM
    5780 views | 2 replies
  • How to globally set levels in a chart

    I have a few scripts that I use that were created from charts. Often these charts have data that JMP separates into levels although for my purposes, they are effectively the same. For example the following code is for a chart of mean exclusion rates across sites.Chart(    X(:IDENT Code),    Y(Mean(:Exclusion Rate)),    Add Error Bars to Mean(Name("Confidence Interval (pooled)")(0.95)),    Overlay ...

    mdawson69 mdawson69
    Discussions |
    Mar 21, 2017 8:03 AM
    6175 views | 5 replies

Latest Discussions

  • How to globally set levels in a chart

    I have a few scripts that I use that were created from charts. Often these charts have data that JMP separates into levels although for my purposes, they are effectively the same. For example the following code is for a chart of mean exclusion rates across sites.Chart(    X(:IDENT Code),    Y(Mean(:Exclusion Rate)),    Add Error Bars to Mean(Name("Confidence Interval (pooled)")(0.95)),    Overlay ...

    mdawson69 mdawson69
    Discussions |
    Mar 21, 2017 8:03 AM
    6175 views | 5 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 Lamine
    Discussions |
    Mar 17, 2017 5:25 AM
    3123 views | 0 replies
  • Get count for grouping (panels) in graph builder to check the visualisation is sensible

    So I have written a bit of JSL which is able to take a data table and make suggestions of graphs. It checks the number of unique values, column data type and column name to assess which graph would be most appropriate. One issue I am having is when it uses Page, Group X, Group Y and/or Wrap and there aren't many data points in the resulting panels. Below is a silly example using Big Class. Clearly...

    stephen_pearson stephen_pearson
    Discussions |
    Mar 16, 2017 6:00 AM
    5183 views | 4 replies
  • Non-Modal windows/user-interactive script

    Hi, Details of my script:Part 1: open a new table so that user fills valuesPart 2: wait for the user to fill values and take the response to proceedPart 3: proceed with the remaining script I am struggling in part 2 because if I use Modal windows, I cannot fill the values in the table.I would like to generate a new window which will wait on user input OK" to proceed but should not interrupt the us...

    shashivenky shashivenky
    Discussions |
    Mar 9, 2017 4:16 AM
    4660 views | 2 replies
  • Negative R2 in Mixed Models

    How is R2 calculated in JMP (v12.2) when fixed and random effects are included in Fit Model? I can't find any documentation on this. The reason this came up is that I have been getting negative R2 values.   

    jwiltsie jwiltsie
    Discussions |
    Mar 8, 2017 7:52 AM
    7816 views | 6 replies

Latest Discussions

  • 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 Lamine
    Discussions |
    Mar 17, 2017 5:25 AM
    3123 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 kevinwtbolger
    Discussions |
    Feb 26, 2017 9:30 AM
    3125 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 msharp
    Discussions |
    Feb 14, 2017 1:53 PM
    4167 views | 0 replies
  • How to Maintain JMP Graphs Table Layout When Copy and Pasting into Word

    For years I've had to build sets of graphs using the Fit Y by X platform. The graphs are simple: X-axis is always (1) a character, nominal column and (2) a numeric, continuous date/time column. The Y-axis is always numeric, continuous data (bins, registers, parameters). The result is a list of box plot on the left, time trend on the right. There could be many plots at a time. In JMP 12 (and I thin...

    MIKE MIKE
    Discussions |
    Dec 14, 2016 8:48 AM
    4485 views | 0 replies
  • Odds ratios for multiway tables

    On twitter earlier today, someone asked if the Cochran-Mantel-Haenszel (CMH) odds ratio (OR) test was available in JMP when the stratification variable is not the X in Fit Y by X. Anytime I need to go from two variables to more than two variables, the first place I look is Fit Model. The beauty of fit model is that not only can I use as many variables as I want, but I can consider interactions bet...

    DonMcCormack DonMcCormack
    Discussions |
    Aug 10, 2016 3:35 PM
    4661 views | 0 replies
view all discussions