Welcome to the JMP User Community!

Latest Discussions

• Absolute value between all points

  I was wondering if there is an easy way to aggregate the absolute value of all points in a column to one another. I have written some scripts which will give me the stage location data for a tool, but I want to see how the locations measure up relative to themselves rather than the absolute locations of the machine. For example:If I have 3 points, I want to know the distance between 1-2, 1-3, and ...

  SG

  Discussions |

  Jun 28, 2017 11:24 AM

  11661 views | 6 replies

• 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

  27125 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

  19157 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

  8451 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

  11187 views | 10 replies