JMP User Community

Latest Discussions

Exporting a JMP Data Table in JSON Format

Hi,
I've been asked whether it's possible for JMP to export a data table in JSON format, where everything contained within that data table - including all table properties and formulae - can be exported in such a way that it can be retrieved (if necessary by coding in another language) by someone else who doesn't necessarily have access to JMP. I've already taken a look at the post below on this fo...
DMR

Discussions |
Jun 29, 2020 1:52 PM

4367 views | 5 replies
Is there a method to get axis values from graph builder?

Hi. I'm interested in knowing there is a scripting method to read the displayed values for an axis in graphbuilder and return them as a list. IOW, is there a function or a message that can "get" the axis values from a graphbuilder reference or an axis box? Something like: xval_lis = gb << Get X Axis Values. For instance, suppose I have the following graph:dt = Open("$SAMPLE_DATA/Big Class.jmp")...
nikles

Discussions |
Jun 29, 2020 10:21 AM

2522 views | 2 replies
Search for filename

Hi. Is there a way to have a script search the user's computer for a given filename and return the path? Im using a Mac and JMP14.3 atm. I'm interested in creating an add-in that calls another script on the user's computer, but I won't know where the user has stored the script. In the add-in, I'm thinking something like this: //Add-in code path = [command or function to search for "myscript.j...
nikles

Discussions |
Jun 29, 2020 10:17 AM

2218 views | 2 replies
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

2195 views | 2 replies

Previous
Next

Latest Discussions

Exporting a JMP Data Table in JSON Format

Hi,
I've been asked whether it's possible for JMP to export a data table in JSON format, where everything contained within that data table - including all table properties and formulae - can be exported in such a way that it can be retrieved (if necessary by coding in another language) by someone else who doesn't necessarily have access to JMP. I've already taken a look at the post below on this fo...
DMR

Discussions |
Jun 29, 2020 1:52 PM

4367 views | 5 replies
Search for filename

Hi. Is there a way to have a script search the user's computer for a given filename and return the path? Im using a Mac and JMP14.3 atm. I'm interested in creating an add-in that calls another script on the user's computer, but I won't know where the user has stored the script. In the add-in, I'm thinking something like this: //Add-in code path = [command or function to search for "myscript.j...
nikles

Discussions |
Jun 29, 2020 10:17 AM

2218 views | 2 replies
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

3935 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

3661 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

1834 views | 2 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

1190 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

1171 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

4431 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

2037 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

1883 views | 0 replies