Welcome to the JMP User Community!

Latest Discussions

• Changing/reading a specific value from a JMP generated (capability) summary table

  Hello! I'm working on a script for an automated CPV exercise. So far I can already generate a report with control charts, a capability summary together with a conclusion for each parameter/attribute for any X amount of columns from the original JMP table (for-loop for each column). My question here deals with the capability summary.In the script, I use the "Process Capability(..)" functionality - ...

  Jonas_Aji

  Discussions |

  Apr 9, 2021 7:27 AM

  1657 views | 2 replies

• Data table - If one column has empty value, then use other column value to fill in,other row keep no change

  Names Default To Here( 1 ); //If the original data table is like below, // there are 2 empty value(:sex[3] and :sex[4] )in column sex: dt = Open( "$SAMPLE_DATA/Big Class.jmp" ); dt:sex[3 4] = black;   I want the function is: when search all values in column :sex, if find column sex have empty value, then fill the column :name value into the empty position in :sex while keep other value in :sex w...

  Theresa

  Discussions |

  Apr 9, 2021 2:33 AM

  1991 views | 1 replies

• Moving column group to 'after column' is only moving it to the first

  ​I'm trying something that seems simple - moving a column group to a location after another column.   Moving "to last" works, "to first" works, but after doesn't for me, no matter how i mess with format.   Below is example code to test -   Names Default To Here( 1 ); dt = Open( "$SAMPLE_DATA/Cities.jmp" ); dt << group columns( "xy", {:X, :y} ); dt << group columns( "pollutants", :Ozone :: :Lead );...

  jetpeach

  Discussions |

  Apr 8, 2021 1:54 PM

  7634 views | 3 replies

• how do I use a formula that subtracts Col B from Col A and divides by Col C but on a per month basis

  I have 3 months of data in my file, Jan, Feb and Mar.I'm using this formula (Col Sum( :A ) - Col Sum( :B )) / Col Sum( :C )But I need the value per month.Thanks

  fionaweston

  Discussions |

  Apr 8, 2021 12:59 PM

  1772 views | 2 replies

• find first element with condition in a column

  Hi, I have a data with 2 columns: group and score, and I want to calculate the 3rd column called first, which returns the "first score by group that is not 10000000000. so in this sample data, group a = 0, group b =53. and since group c only contains 10000000000, nothing shows up for it.Could someone help me with a jmp formula for this column but not jsl? Thank you so much!groupscorefirsta10000000...

  joann

  Discussions |

  Apr 8, 2021 9:36 AM

  4760 views | 6 replies