Welcome to the JMP User Community!

Latest Discussions

• Filter by row, stack columns?

  I know how to make a subset table based on some criteria:dt << Row Selection( Select where( (:Stat == "mean"), Current Selection( Extend )) ); dt << Select Columns( [10, 20] ); dt2 << Subset( Output Table( "test"), Selected Rows( 1 ), Selected columns( 1 ) );But now I need to repeat the above for multiple criteria and stack the selection, i.e. the new table will have Column 10 as a fixed column, a...

  student

  Discussions |

  Apr 27, 2021 4:03 PM

  5796 views | 15 replies

• Custom DOE Returning Rsquared of 1

  Hello All, I am running a custom design DOE with 3 factors at 2 levels each but limited to only 10 runs. One of my factors is a hard to change variable. I have 4 responses in my DOE, 1 rated with importance of 1, 2 with importance of 2 and the remaining item with importance of 3. As you will see from the attached file, when the model script is run I get an RSquare value of 1 for "Delta in ROn Mean...

  GSheehan1

  Discussions |

  Apr 27, 2021 3:49 PM

  1033 views | 1 replies

• JMP 14 column ordering difference

  Any idea why an order of table columns is different to when others running same script? The content is the same the order is different.
  
  For example I get column order TEST-9, TEST-12, TEST-17
  But others would get TEST-12,TEST-17,TEST-9
  
  The latter result is what I need to get is this a setting somewhere I need to change or a difference from JMP13 and JMP14?
  
  Many thanks for any help given

  AlexS

  Discussions |

  Apr 27, 2021 12:35 PM

  2937 views | 6 replies

• Part of my script makes a subset of my data. At the very end of my script I try to graph of the subset of data.

  Everything else runs fine except for I don't get a graph built for my Subset data table.
And I don't get any error. Any ideas what is wrong?

Thanks

First part is making the subset
Second is calling the subset to make the graph

//MAKE CANCELLED INTO SUBSET // New column: Column 1 Data Table( "Work Order Log" ) << New Column( "Column 1", Numeric, "Continuous", Format( "Best", 12 ), Set Selected ) <...

  fionaweston

  Discussions |

  Apr 27, 2021 12:29 PM

  1597 views | 2 replies

• JSL Sum changing columns

  Hello, if I have a table that changes once in a while something like this: but another day it can be something like this:and I want to somehow create a new row that will sum all the columns except for Date and Datawhat is the best way to do this in JSL?I tried taking the columns names and then removing data and date but then I'm not sure how to do the sum part for each columnI tried using summary ...

  itzikd

  Discussions |

  Apr 27, 2021 12:04 PM

  1602 views | 3 replies