Welcome to the JMP User Community!

Latest Discussions

• Reference Table file name in SQL query

  Hi @stan_koprowski , I used JMP Query Builder to create the following SQL Query Names Default To Here( 1 ); //Prompt to select and open an MS Excel file dt1 = Open( Pick File( "Select Excel File", "$DOCUMENTS", {"Excel Files|csv;xlsx;xls", "All Files|*"}, 1, 0 ), Invisible ); //Prompt to select an open a JMP data table dt2 = Open( Pick File( "Select JMP File", "$DOCUMENTS", {"JMP Files|jmp", "All...

  Jackie_

  Discussions |

  Mar 25, 2020 9:24 AM

  3943 views | 1 replies

• JSL Script: Graph Builder to plot all columns of a data table

  Hi All, Long time JMP user (novice at jsl scripting ), first time poster. I'd appreciate any help!  I am writing a script that does two things: 1. open a text file, import the numeric data, and then save the data table, so I can open it later.2. use Graph builder to plot all the "y-axis" columns at once I have no problems with item #1, so no comments on that are needed. Item #2 is giving me proble...

  dProbela

  Discussions |

  Mar 25, 2020 9:16 AM

  8665 views | 4 replies

• Orthogonal regression intercept CI

  I need support in interpretation results of 2 methods bridging (210 vs 280).The results of Bland Altman plot and orthogonal fit are below. How to calculate in JMP CI for intercept in this case?I need to know if 27.2 is significant. It should not be... Results differ with mean difference around 0.27.

  A_Tomczyk

  Discussions |

  Mar 25, 2020 7:41 AM

  6615 views | 8 replies

• Combining graph windows with interactive column switcher

  Hi,I have created two different graphs based on the same data table with different variables that need to be reviewed together by end users. I have added a column switcher to make it easy for the user to go through the different variables. Next I combined the two graphs in a single dashboard using the "combine windows" as it was my understanding that this would maintain the interactive capabilitie...

  JulieSAppel

  Discussions |

  Mar 25, 2020 6:59 AM

  4106 views | 5 replies

• Compare Rows by Group

  Hi,I'm trying to write a script comparing rows by group but am having trouble figuring out how to do this    In the table below, I'm trying to select rows that meet both of the following conditions within a group (i.e. by "Subject Number" column):Value in "Target # Days from Previous" column is greater than the row with a value of zero (in example below highlighted rows 71 through 82 have values g...

  christine_kim0

  Discussions |

  Mar 25, 2020 6:55 AM

  9125 views | 3 replies