Welcome to the JMP User Community!

Latest Discussions

• split data table without including excluded data

  Hello all, I am trying to split a data table that has some bad data in it. I have exleded those bad data in the original table, but I don't know why those data are showling up in split table. My script is bellow:dt_daily << New Column( "Outliers Exclusion", Numeric, Continuous, Formula( If( :Mahal. Distances > 1.96, 0, 1 ) ), eval formula );dt_daily << select where( :Outliers Exclusion == 0 ) << e...

  Anonymous

  Discussions |

  Jun 20, 2023 8:33 PM

  4353 views | 6 replies

• 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

  7890 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