Welcome to the JMP User Community!

Latest Discussions

• Is it possible to get a row & columns from an open table as inset in to a chart?

  Attached is an example similar to what I want to achieve using JSL i.e. how to get desired rows and columns from an open table in a chart plotted by JMP? I do not want the table of desired rows and columns to cover the plotted data so placement is also important (top left corner or bottom left corner options work best for me). 

  Neo

  Discussions |

  May 19, 2023 6:56 AM

  2398 views | 3 replies

• Get Y axis column name from the variability chart

  Hi, Is there a way to get the Y axis column name from the variability? I tried using get Y axis but doesn't work. Any suggestions?Names Default To Here( 1 ); dt = Open( "$SAMPLE_DATA/Variability Data/2 Factors Crossed.jmp" ); obj = dt << Variability Chart( Y( :Measurement ), X( :Operator, :part# ) ); ax = obj << get y axis; Show( ax );chart  

  Jackie_

  Discussions |

  May 19, 2023 6:17 AM

  1631 views | 4 replies

• Formatting is not accepted (col << Format( "Fixed Dec", 10, 2 )) and still getting 3 decimal point as the output. What am I doing wrong?

  Hello dear community, I am assigning the two decimal point format to a column but when i extract this value it is still showing 3 decimal points. I would appricate your input. Here is an example:// Open Data Table: Antibiotic MICs.jmp // → Data Table( "Antibiotic MICs" ) Open( "$SAMPLE_DATA/Antibiotic MICs.jmp" ); // Standardize column attributes-The main idea is the format= Fixed Dec, 10, 2-show...

  Aziza

  Discussions |

  May 19, 2023 12:39 AM

  1566 views | 3 replies

• Get values in the list from SQL query

  Hi, Is there way I could insert the column values in the list than jmp table?
  
  I 'm trying to write a JSL code to query data from database and I want to store the values from the SQL table into a variable list (not in the JMP table).
  For example, save the WorkCenter sql table values in the list= {};
  Any suggestions?
  
  Thanks,Jackie

  Jackie_

  Discussions |

  May 19, 2023 12:04 AM

  2339 views | 4 replies

• How can I get the sum of all different combinations of a group of columns?

  Hi,I am using JMP PRO v16I have a group of 10 columns with numerical values, and I want to try to get a sum of the scores in all possible combinations between these 10 columns (e.g., column A+ column B, column A+ column B + Column C, Column B + Column C and so on). Thank you so much for your help

  DivisiveFerret8

  Discussions |

  May 18, 2023 3:46 PM

  2677 views | 6 replies