Welcome to the JMP User Community!

Latest Discussions

• How to pass parameters to the specified JSL in the graph fetch?

  Examples in the index of softwaredt = Open( "$SAMPLE_DATA/Big Class Families.jmp" ); gb = dt << Graph Builder( Show Control Panel( 0 ), Variables( X( :age ), Y( :weight ) ), Elements( Bar( X, Y, Legend( 7 ) ) )); frame = (gb << report)[FrameBox( 1 )]; frame << Set Graphlet( Picture( loader = Include( "$BUILTIN_SCRIPTS/hllib.jsl" ); hlp = loader:lazyLoad( "hllPresets" ); hlp:launchPie(); ), Titl...

  lala

  Discussions |

  Feb 22, 2024 12:55 AM

  4297 views | 11 replies

• group file name and set lable by JSL looping, work fine but slowly

  I have a JLS works fine, but slowly, is there any method to improve it? 1. import multiple files2. base on file name rule group into a, b, c, d, e 3. base on file name rule to decide file count and set into rows for each groupNames Default To Here(1); dir = Pick Directory( "Select a directory" ); Multiple File Import( <<Set Folder( dir ), <<Set Show Hidden( 0 ), <<Set Subfolders( 0 ), <<Se...

  BayesRabbit7133

  Discussions |

  Feb 22, 2024 12:24 AM

  861 views | 0 replies

• Working on multiple data files and creating a summary table that contains the mean, std, etc.

  Hi,  Lets say we have multiple big class data files, with different height, weight column, etc and I want to create a summary table that contains the mean, standard deviation,  cpk, Spec limits, etc.  I want to have a summary data table that lists the mean for example, for the first big class file, do the same thing for the next big class file. Is there are a method that I can use to perform such ...

  RA899

  Discussions |

  Feb 21, 2024 10:07 AM

  1647 views | 3 replies

• Excel cell format

  Hello 
  
  I'm encountering an issue with inconsistent cell formatting across multiple Excel files. I've written a script that imports all Excel files within a specific folder and then creates a new table with selected data from these files. However, I'm running into a problem because some of the Excel files have cells formatted as 'General', while others are formatted as 'Number'. This discrepancy in ...

  SeasonalControl

  Discussions |

  Feb 21, 2024 7:34 AM

  1452 views | 2 replies

• How to add JSL to "Big Class.jmp" graphics using Hover Labels?

  Start with the following JSL to generate the graph.
  How to add JSL through Hover Labels to get cell name data Get "Big Class Families" file corresponding name data?dt = Open( "$SAMPLE_DATA/Big Class.jmp" ); p1 = dt << Graph Builder( Variables( X( :weight ), Y( :height ), Group X( :age ), Color( :sex ) ), Elements( Bar( X, Y, Legend( 5 ), Response Axis( "X" ) ) ) );

  lala

  Discussions |

  Feb 21, 2024 7:09 AM

  2682 views | 8 replies