Welcome to the JMP User Community!

Latest Discussions

• 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

  13081 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

  11859 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

  12149 views | 3 replies

• Creating a 2X2 table from continuous data

  Dear community,
  I have a 2 columns of continuous data. I would like to make a 2X2 table out that continuous data. I am trying to use this for sensitivity and specificity. I have a gold standar test and a new test. I want to set cutoff and get a table like this
  -------------
  | AB | Ab |
  ------------
  | aB | ab |------------
  
  ie AB would the the number of values that are above both cutoffs. ab is is number...

  drsultan85

  Discussions |

  Aug 13, 2013 4:02 PM

  4011 views | 1 replies

• how delete empty rows

  Im just new in jsl and i would to know how to delete a multiple row with empty field using jsl script , below is the sampleOPTION    SNTest            407739Test            407753.Test            407770.Test            407785Test           407811

  cire_kups

  Discussions |

  Aug 11, 2013 9:27 AM

  19518 views | 2 replies