Welcome to the JMP User Community!

Latest Discussions

• [Script] Color Gradient Output

  R1=(dt<< Tabulate(
  Show Control Panel( 0 ),
  Show Tooltip( 1 ),
  Add Table(
  Column Table( Statistics( N )),
  Column Table( Grouping Columns( :Name( "TEST" ) ), Statistics( Row %, N )),
  Row Table( Grouping Columns( :Radius ) )
  )
  )) << Make Into Data Table;R1:"N(1)"<< Set Property( "Color Gradient", {"White to Orange", Range( {0, 547, 187.945945945946} )} )
  << Color Cell by Value;
  R1:"N(8)"<< Set Property( "Colo...

  kuanaunwei

  Discussions |

  Jun 28, 2017 12:57 AM

  10915 views | 10 replies

• Wildcard selection of characters from a given file name

  Hello,I am trying to look up certain characters from a file name and select those file.for eg: file name: HELLO123_MT_XYZ, Code:For( i = 1, i <= N Items( files ), i++,If( Contains( files[i], "MT" ), //Enter search criteria from file nameOpen( files[i] );));Above code with "MT" will pull all file names with MT as character. But how can i select files with wild card? for eg: *123*XY*

  CG

  Discussions |

  Jun 27, 2017 11:19 AM

  12813 views | 8 replies

• Distribution analysis (e.g. summarize statistics) direct calculation after selection?

  Dear all,
  I´m sure its an easy question - so for you I think its an quick and easy answer :)
  
  I would like to calculate the data in the distribution-overview based on the selection:
  
  Here for example I would like to see the summary statistics direct after selecting this data (new table calculation). For now I just can see this specific calculation if I Hide and Exclude the unneccesary data in the raw-d...

  Fabian88

  Discussions |

  Jun 27, 2017 6:39 AM

  13030 views | 9 replies

• method comparison for censored data

  Hi group, I would like to compare thow analytical methods that are interval-censored (limit of quantitation - upper limit of quantitation). So I have observations with values of <3 (LOQ) as well as >120 (Upper LOQ). Usually Bland-Altman would do but in this case I am not sure.Some people suggest for the lowest to substituting BQL observations with LOQ/2. But how about the upper LOQ?There was discu...

  david_arteta

  Discussions |

  Jun 27, 2017 5:17 AM

  13463 views | 11 replies

• Select a group of cells in a column

  Hi, I have table with thousands of rows. I need to be able to select a group of cells in one column, so I could copy it into another table. for example for Column: "Test3 (VOLTS)" only I need to copy cells highlighted in yellow from row 4 thru row 18 using JSL code.Thanks 

  SamH

  Discussions |

  Jun 26, 2017 3:21 PM

  16486 views | 11 replies