Welcome to the JMP User Community!

Latest Discussions

• Add secondary x-axis but don't sort by it

  This is going to be hard to explain by text so please see images below. Basically I'd like to have grouped by category below the main x-axis without it messing up the sort order. Whilst it's possible to have category "above" the main x-axis, this doesn't look nice and causes category grid lines to be drawn every entry instead of only when it changes. 

  david707

  Discussions |

  Jul 10, 2019 3:02 PM

  3601 views | 1 replies

• Set column width with JSL?

  Is there a way to set the display width of a column using JSL?  When I create a table, by default the columns are too wide.  I've tried playing around with set column width but it doesn't work.I know that the column width is stored somewhere, because if I set the column widths manually, save the dataset, and then open it again, voila the widths are preserved.  I just don't know how to do it in JSL...

  pmroz

  Discussions |

  Jul 10, 2019 2:20 PM

  20118 views | 7 replies

• Set Current Directory

  Hi.  I have written some sentences to set the current directory where to find the files of interest but it dones not work. Any help? Thanks     Set Current Directory( "/Users/manel/Desktop/Municipales_Spain" ); my_file = Pick File( {"All files|*"} ); dt = Open( my_file ); dt << Select Where( Código de Provincia == 44 ); SubDt = dt << Subset( output table name( "Matarranya1" ) ); Close( "Mata...

  gallardet

  Discussions |

  Jul 10, 2019 1:10 PM

  8995 views | 5 replies

• How to group multiple data transformations into one script

  Hello, I'm kind of new to scripting, and I was wondering if anyone can help me with finding resources to learn about how to put this process into one script. Here is an outline of the work that I have done. 1.  Use tabulate to create summaries from an original table2.  Save tabulate as data table (the result is 3 separate tables)3.  For each of the 3 tables     a.  Add a new column with a formula ...

  JeffSwartzel

  Discussions |

  Jul 10, 2019 12:36 PM

  2950 views | 2 replies

• Add a new window for Start & End Calendar date selection box/ date entry box

  Hi JMP community, I usually use jmp preselected and plot graphs need a help to add selection date amend for my script below.   As per below, once I call out database, I have to amend the dates for start & end in order to query needed data on input dates.   dt = Open Database( "DSN=xxx ;Description=yyy;UID=zzz;PWD=zzz;APP=JMP;DATABASE=MATS;", "SELECT pen_parametric.pn_id, pen_parametric.equiplk_k...

  OtisZeca

  Discussions |

  Jul 10, 2019 12:02 PM

  6020 views | 4 replies