Welcome to the JMP User Community!

Latest Discussions

• can we color the cells in jmp table as we do in excel? I mean really give colors to the part of table/cells interested

  can we color the cells in jmp table as we do in excel? I mean really give colors to the part of table/cells interested? I tried below jsl but it only works when you plot the data in graphs but not in the table itself?   Thanks in advance! Evan     dt=Data Table( "Bin Wafer Map" ); For(i=4, i<=N col(dt),i++, dt:i << Set Property( "Value Colors", {1=Green,3 = Red, 4 = Yellow,5=orange, 6 = Magenta, 7...

  robust1972

  Discussions |

  Jun 28, 2017 6:23 AM

  24608 views | 12 replies

• 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

  16453 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

  7513 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

  8896 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

  11334 views | 8 replies