Welcome to the JMP User Community!

Latest Discussions

• 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

  2337 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

  2675 views | 6 replies

• How to pass values to Min and Max for Axis via Set Property?

  The following works for myCol in dt. myCol is Numeric and ContinuousNames Default To Here (1); dt = Current Data Table(); dt:myCol<< Set Property("Axis", {Min(0.02), Max(10.05), Inc( 0.01 ), Minor Ticks( 1 )});However the following results in a JMP (v 16.2.0) crash. Where am I going wrong?ll = 0.02; ul = 10.05; dt:myCol<< Set Property("Axis", {Min(ll), Max(ul), Inc( 0.01 ), Minor Ticks( 1 )});Che...

  Neo

  Discussions |

  May 18, 2023 8:13 AM

  2246 views | 3 replies