Welcome to the JMP User Community!

Latest Discussions

• Create a formula for temporary variable

  Hi all,  im still new to JMP scripting. I need help to create a formula to make the value as a variable but with its own name. What i mean is as below. So, i want to create a formula that can make column 4 below as a variable for distribution graph.  it is like Plastic = 0.424542 the problem right now is the formula name will be in the same which is t4 = :TYPE;:MIN;. So if i want to plot the min v...

  mhalwi

  Discussions |

  Feb 11, 2018 3:04 AM

  22056 views | 15 replies

• How do I delete rows of variable column numbers when all are missing data

  I have an auto-generated dataset and some of the columns, those that have a substring "X_Clean" in it, will have some null values.  Sometimes there are 2, 3, 4 or even 5 different columns, depends on the dataset.  I want to delete the rows only when ALL "n" of these "X_Clean" columns have null values but never if at least one of them is populated with a value. I was thinking of doing a FOR loop to...

  MuttonChops

  Discussions |

  Feb 10, 2018 8:47 PM

  8513 views | 4 replies

• How to check if a list contents is all numeric without loops

  Hi,
  
  I am writing some code which imports data and I would like to do some data checking similar to MessyTables for python.
  
  Data can be accidentally imported as character due to "NULL" or similar being present in the data. After removing the common instances of these I would like to check the data again to see if it is numeric.
  The easiest way to do this is to use Try() and Matrix() after removing a...

  stephen_pearson

  Discussions |

  Feb 10, 2018 1:17 PM

  17856 views | 8 replies

• How to Add Row Legend to Control Chart Report & Hide Data Table

   Hello, Once i've created a control chart script, how do i:1) Add a Row Legend to the PLOTS window based on TOOL?2) Hide the data table, but keep the PLOTS screen visible?
   dt = Open Database( "Database1",
  "SELECT
             MEAS1,
             TEST_DATE,
             TOOL
  FROM Data_Table_1
  where  Test_Date > sysdate - 365
              order by test_date asc
  ",
  "dt"
  );
  
  dt << Color by Column( :TOOL, Color Theme( "J...

  Tom_P

  Discussions |

  Feb 9, 2018 9:40 AM

  6028 views | 2 replies

• Why DF of pure error of LOF test change when terms are added or removed from the model?

  Hi JMPers, I was modeling with fractional factorial design 2(7-4) with 3 center points.When I change the terms in the model, DF of pure error in the LOF test also changes. (10 to 14)                In Minitab it doesn't change with the change of the model (same DF = 2 for 3 replicates of center points).                I think that DF of pure error is calculated from the number of pure replication ...

  kimmbb

  Discussions |

  Feb 9, 2018 8:06 AM

  12059 views | 8 replies