Welcome to the JMP User Community!

Latest Discussions

• Proper syntax to color cells where column name has a space

  Hi, I found in the forums that you can color table cells by sending the color cells(...) command to a table column.It works fine when sending to a column with no spaces in the column name, such as ":Roast", however a column title with a space fails.  What is the proper syntax for column names with spaces? Thanks.---------------------------------------------------------------coffee_dt = New Table()...

  senatorx

  Discussions |

  Aug 22, 2013 8:53 AM

  8921 views | 1 replies

• Using graph builder to create graphs with grouped Y data

  Hello,I am a tropical ecologist specialising in the Amazonian canopy. I am writing my PhD thesis and using JMP Pro (I'm a fairly new user with no programming experience) to run PLS and other analyses on my data. I have a large dataset of leaves grouped by tree, leaf canopy level (sun or shade) and leaf age. For one of my first analyses I have 12 trees with 4 trees having both sun and shade leaves ...

  cchb

  Discussions |

  Aug 20, 2013 12:28 PM

  27473 views | 15 replies

• How to create a calculated column similar to pivot table in Excel?

  I want to use graph builder to slice and dice attrition data. In Excel I would use what is called a calculated field within a pivot table.My data would look like the attached, where I can select any field as row(s)s or column(s) and the attrition rate would update dynamically since its a caculated field.How do I do this in JMP? I tried HC/TER and sum(HC)/sum(TER). I did this in the data detail as ...

  danlopez

  Discussions |

  Aug 20, 2013 11:45 AM

  13088 views | 1 replies

• Refresh Graph in Dialog Box

  I'm displaying a radio box and a graph in a "new window".  If the user selects a different graph in the radio box I want the old graph deleted and the new graph displayed, all in the same window.  Not sure how exactly to do this.  Here's a simple example that displays the first chart.  dt = open("$sample_data\Big Class.jmp");my_1_script = expr(    my_gb = Graph Builder(        Show Control Panel( ...

  pmroz

  Discussions |

  Aug 16, 2013 10:29 AM

  11866 views | 3 replies

• Assign a value in a list to column values

  By using a modal window, the user assigns a value (for example "ABC10") to a variable (my value) and I would like to fill a column with that value. My code looks like this:my value = { "ABC10" };dt << New Column( "My Column");For Each Row( :My Column[] = my value);I am having trouble because my value is a list and the expression does not fit available column types. Can anyone help me out?

  hacketkm

  Discussions |

  Aug 14, 2013 11:57 AM

  12153 views | 3 replies