Welcome to the JMP User Community!

Latest Discussions

• Change font color within TableBox with JSL

  Is it possible to change the font color for individual cells within a Tablebox? I found an older post that said this wasn't possible without conditional formatting: https://community.jmp.com/t5/Discussions/Is-there-a-way-to-send-a-font-color-to-a-single-value-in-a/td-p/8643 And conditional formatting won't work for this project. I was hoping this functionality had been added since the older post w...

  ABI

  Discussions |

  Jun 28, 2017 6:09 AM

  18849 views | 10 replies

• Script for Control Charts (all numeric Columns) with saved Limits in one table

  Hi, I'm trying to generate one Window/Report with several Control Charts (all numeric columns of the data table). So far I was able to generate this report. But I'm not able to save all Limits in one data table. Can anybody help me? Following my codedt = Current Data Table (); //Deselection von allen Spalten cols = dt << get column names(); For(i = 1, i <= N Col(dt), i++, cols[i] << set selec...

  mkennke

  Discussions |

  Jun 28, 2017 2:50 AM

  8347 views | 3 replies

• [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

  10914 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