Welcome to the JMP User Community!

Latest Discussions

• How to trigger a button to open "Save File Windows Explore" via JSL?

  I am trying to get help from community members to see that if a "Save File Windows Explore" can be triggered as below screenshot after a button-clicking event? Is there anyone who has an idea? Thanks in advance.      

  baiyun

  Discussions |

  Mar 11, 2021 11:13 PM

  2629 views | 6 replies

• How do I create a counting variable based on another column & transpose a table?

  Hi all,I'd appreciate help with reformatting a clinical dataset. It records ~50 variables for multiple patients on multiple visits. So there are ~51 columns with one being an MRN or record number per patient. There are typically 6-7 rows of data per patient/MRN to report on variables taken at different visits. So 2 questions: 1)How can I generate a new incremental count variable that counts number...

  acm

  Discussions |

  Mar 11, 2021 4:13 PM

  1720 views | 1 replies

• Process Capability - Summary report: color of process stability column

  I made a process capability analysis of 7 processes. Although the 7th process is very unstable with stability index = 1,30 in the summary report it is labeled as green where is should be red as in the process performance report, see below. Is it possible to adjust the color of the Stability Index (SI) column to red according to the SI target?  

  frankderuyck

  Discussions |

  Mar 11, 2021 2:03 PM

  2769 views | 5 replies

• check if data exist in another table

  Hi, I have 2 tables A and B, each has a column "email" and "id". I want to add a new column in table A, if that row has "the same email OR same id" showing up in table B, then "YES", if no then empty. Could someone help me how to write this script?  Thank you.

  joann

  Discussions |

  Mar 11, 2021 10:35 AM

  4116 views | 7 replies

• combine formula

  Hi, could someone help me combine the 2 formulas below? The second one is simply minus the time of day part. Thank you.   ----------------------------------------   New Column( "week start", Numeric, "Nominal", Format( "m/d/y", 12 ), Input Format( "m/d/y" ), Formula( If( Day Of Week( :WR_Date ) == 1, (:WR_Date - In Days( Day Of Week( :WR_Date ) )) - In Days( 5 ), (:WR_Date - In Days( Day Of Week( ...

  joann

  Discussions |

  Mar 11, 2021 8:40 AM

  1764 views | 4 replies