JMP User Community

Latest Discussions

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

3495 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

12377 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

2671 views | 5 replies
How to determine differences between each pair of categorical data with 3+ groups

Hi! I feel my question is pretty straight forward. How can I determine differences between each pair of categorical data with 3+ groups?I have two categorical variables:1) Type of Grant (Grant 1, Grant 2, Grant 3, & Grant 4)2) Professorship (Assistant professor, associate professor, full professor) I can use Fit Y by X and get a significant Chi Square value between the two.... But how can I tell w...
jmpvmd

Discussions |
Jun 28, 2020 6:00 AM

2082 views | 1 replies
DoE: What to do if some conditions of a design are almost impossible to run?

Hi All, Assume we have 3 factors with 2 levels each. If I understood it correctly, for small number of factors we can consider a full factorial design, in this case would be 2^3 full factorial design. What should we do, if by some reason, 2 out of 8 conditions is not possible to run? Is there any way/concept to handle this situation? Thanks in advance!
Aziza

Discussions |
Jun 26, 2020 6:23 AM

3748 views | 7 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

3137 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

2810 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

1428 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

984 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

4077 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

984 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

945 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

3583 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

1629 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

1486 views | 0 replies