Welcome to the JMP User Community!

Latest Discussions

• Convert City to Lat/Long Coordinates

  Is there a way in JMP, either built in, an add-in or JSL code, to take a column (or columns) of City and States/Countries and convert them to latitude and longitude coordinates for plotting on a bubble plot?

  Anonymous

  Discussions |

  Aug 29, 2013 6:22 AM

  9498 views | 2 replies

• 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

  27457 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