Welcome to the JMP User Community!

Latest Discussions

• Convert Work Week into Date (JMP10)

  Hi,I have a data set that lists work week, and I am trying to convert this number into a calendar date.  I know JMP has a function to convert calendar date into work week, but I would like to do the opposite.For example, I have a number like 201334, representing YYYYWW.  How can I convert this back into a date?  My reason is that I would like to be able to plot this data on a time trend, but witho...

  robot

  Discussions |

  Aug 22, 2013 1:24 PM

  10157 views | 2 replies

• 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

  27454 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

  13080 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

  11856 views | 3 replies