Welcome to the JMP User Community!

Latest Discussions

• Creating New Rows based on Averages from Previous Rows?

  Hello,Perhaps this is a quick fix, but I have a large data-set in JMP with many categories, one of which is a subgroup that each entry belongs to. I'm looking to take averages of the data collected across the entire subgroup and use it to create a whole new row. Is this possible using scripting? I am hoping for an optimized workflow where all it takes is a button to do this across different files....

  WebArmadillo869

  Discussions |

  Jun 20, 2023 2:11 PM

  1184 views | 2 replies

• should i use principal component analysis or k-means cluster analysis?

  Hi - I am trying to decide the best method of cluster analysis (e.g. principal component analysis, k-means, etc) to use for the following situation.  I have a mapped dataset with 12,928 records, each corresponding to a well with sample results.  Each row of data (each location on my map) has a well name, latitude, longitude, and results of compound A, compound B, compound C, compound D, compound E...

  learning_JSL

  Discussions |

  Jun 20, 2023 12:25 PM

  7884 views | 10 replies

• issue to insert date variable into customsql

  Hi,I want to set the start and end datetime as variable then insert into customsql. in method one below, JMP Alert of converting issue. When I simply hard coded the start and end date as variable, it run without issue. I check both the start and end date type in both method, both are string(). Event the custom sql after substitute into are identical. I cannot find out why the method one not workin...

  dadawasozo

  Discussions |

  Jun 20, 2023 11:48 AM

  1486 views | 4 replies

• How to set Scale Values in Graph Builder use Col Quantile function?

   HI, I want  set Scale Values in Graph Builder use Col Quantile function,  but always something wrong. the red code have some problem. I need color scale as Quantile Graph Builder( Size( 839, 726 ), Variables( X( :Prober_X ), Y( :Prober_Y ), Color( :OpticalPower ) ), Elements( Points( X, Y, Legend( 6 ) ) ), SendToReport( Dispatch( {}, "400", ScaleBox, {Legend Model( 6, Pr...

  Solarwing

  Discussions |

  Jun 20, 2023 9:32 AM

  657 views | 0 replies

• Correlation Coefficient Calculation

  I'm trying to determine the correct way to caclulate the correlation value given in the table of correlations for a given DOE design (this is found in the color map when generating a DOE design). JMP support specialists have shared this formula with me, but I'm not sure it is matching. I'm attaching the small JMP file I'm examining as an example. 

  TriangleDJT

  Discussions |

  Jun 20, 2023 8:58 AM

  4612 views | 7 replies