JMP User Community

Latest Discussions

Recode Column Names - Save Script?

Hello, Using JMP 15 Pro and it does not seem that with the Recode Column Names feature under Cols > Utilities > Recode Column Names there is an option to save the script to a script window or clipboard for future use. This option is readily available with the Recode feature for recoding column values but I can't seem to find something similar for saving the script from Recode Column Names as shown...
Joseph_Reese

Discussions |
Jun 29, 2020 9:57 AM

1785 views | 1 replies
Connecting table variable to slider box

I have a table variable A that is connected to some formulas in my data table.dt = currentdatatable(); dt << Set Table Variable( "A", 1 );I want to build an application using the Application Builder where I move a slider using the Slider Box and this updates my table variable A in the data table, i.e. if the slider is changed to 2, A is updated to 2 in the data table.How could I connect those two?...
Feli

Discussions |
Jun 29, 2020 5:49 AM

2196 views | 2 replies
Extract hours to the nearest hours from duration ( hour:min) format

Hi Guyshow to extract hours from the duration ( hr:min) formant and round the min into the hoursexample:15:26 : 15 hours and 26 minI want : 1516:38: 16 hours and 38 minsI want :17 as 38 min is over 30 mins Appreciate your help
sweetycha

Discussions |
Jun 29, 2020 5:24 AM

4456 views | 6 replies
How to Set Cell Height or Text Wrapping in a Table Box

I'm trying to display some information in a Table Box in a display window. The text in one cell is so long that it extends the column width but does not wrap the text to extend the cell height. Is there a way to change this in the script so that the cell is taller and not wider? This is an example of my current script: longstring = "In the loveliest town of all, where the houses were white and...
vheber

Discussions |
Jun 29, 2020 4:54 AM

13499 views | 5 replies
Enable column operations in custom UI (JSL)

Hello, I've built a simple UI to simplify using the response screening platform and subsequent operation for the user. In one column selection panel, I have list of all the continuous columns the user can select before moving forward. In some case, the user might want to perform an operation on the column (such as log transform) before selecting the resulting transient column.In most platform, thi...
Sburel

Discussions |
Jun 28, 2020 4:00 PM

3441 views | 5 replies

Previous
Next

Latest Discussions

Analysis using data from specific rows and columns

Hi all,I have data for some batches and each batch has different streams(so in each row I have different parameters for a specific stream in a batch). I want to find parameters affecting, say yield, of a specific stream in all batches. It seems that this task is not straight forward. One way that my friend (@ressel) showed was extracting data for that specific stream using Data Filter in a new tab...
Hamid

Discussions |
Jun 25, 2020 11:59 PM

3943 views | 4 replies
Event lines and comments in Graph Builder

Hello, I am trying to map multiple "suspect" lots on our manufacturing line with "TimeStamp" in X-axis and "Process Step" in the Y-axis. I wanted to superimpose tool maintenance "events" on this data. Ideally I wanted a similar look for the "event" as shown in the post Event Lines and Comments on Control Charts . I am badly stuck trying to implement this on a graph builder. Any tips would be g...
bharathu

Discussions |
Jun 25, 2020 6:41 PM

3666 views | 3 replies
Creating categorized line graphs from scatter plot

Hi all,

I am trying to create a line connecting different points within a scatter plot. For my example, I am trying to create a visual that compares the profile of a subset of variables, "isomers", and I want to create a fingerprint by connecting the points in the scatter plot.

The first problem I am encountering (green in visual): I want to have the 3 different 'types' (near surface, bioactive an...
MikeDereviankin

Discussions |
Jun 25, 2020 2:02 PM

1838 views | 2 replies
[JSL Contour Plot] Method of define contour plot, number, minimum, maximum

The contour plot is very helpful to show 3D map, however the problem of defining the zone is always a trouble. In my typical jsl plot, I use something below to define the contour plot zone number = 8, maximum = 1.4, minimum =1. However, the table column :Length may change time to time, and the scale will have to be modified manually for each corresponding plot. Does someone have experience how t...
Stokes

Discussions |
Jun 25, 2020 12:09 PM

1194 views | 0 replies
open and work on different excel files

hi allIm trying to build a script that will open an excel file from a folder and will filter this file based on conditions that might change from time to time.I need the user to state the file name and the conditions for that time, base on whatever he needs from 3-4 columns.Ive tried to do that manually and take the script but it never worked.Can anyone assist?
Tomer_Aminizar

Discussions |
Jun 24, 2020 11:26 PM

5078 views | 8 replies

Previous
Next

Latest Discussions

[JSL Contour Plot] Method of define contour plot, number, minimum, maximum

The contour plot is very helpful to show 3D map, however the problem of defining the zone is always a trouble. In my typical jsl plot, I use something below to define the contour plot zone number = 8, maximum = 1.4, minimum =1. However, the table column :Length may change time to time, and the scale will have to be modified manually for each corresponding plot. Does someone have experience how t...
Stokes

Discussions |
Jun 25, 2020 12:09 PM

1194 views | 0 replies
Impact of screen resolution on html output

Hi, I'm preparing a dashboard using jmp that will be used for a daily meeting. It contains information in form of data tables and text boxes. In order to transfer text sizes and colors for the text as well as the data tables into the html output I transformed them into pictures (rep = dt << get as report(); pic = rep << get picture(); ). I set up all font sizes on my external monitor and it worked...
Ole

Discussions |
Jun 9, 2020 6:21 AM

1175 views | 0 replies
How do I have two different chart types in a single graph using two axis?

While doing some research to answer this question, I found this article on the JMP community that helped me get started. How do I do a combination bar and line plot using Overlay Plot? Using the big class sample data example of height and weight I was able to create a bar chart for weight and a line plot for height on the same chart using the Overlay Plot. To do this, first clear the row s...
Bass_Masri

Discussions |
Apr 28, 2020 4:28 PM

4434 views | 0 replies
How do I calculate z-scores at different aggregation levels?

Hello, How do I use JSL to calculate Z-scores at different levels of aggregation? I am working with cancer mortality data (1999 - 2015) at the county-level. I need to calculate Z-scores to compare each county to the others within a state and all counties within the country. I cannot simply use the standardize function because it automatically takes an average of rates--which is invalid unless the...
Jmsouch

Discussions |
Feb 26, 2020 7:04 AM

2038 views | 0 replies
Calling Windows API ImageViewer.dll to display JPG files.

I am working with a very large database of image files and want to be able to display the file for the user for visual inspection from a script. I have been able to get the following code to load the DLL but get an error requesting a signature argument. Does anyone know how to get a signature string from the system to pass to the DLL. ERROR MESSAGE FORM LOG: Second argument to CallDLL must be a ...
DMeakin1

Discussions |
Jan 17, 2020 10:19 AM

1885 views | 0 replies