JMP User Community

Latest Discussions

Sorting data By JMP

Hi everyone, I have question... how can I sort data like SAP it does?1. SAP ... batch numbers on the rise2. JMP ... letters in priorityThank you in advance!
Leonard

Discussions |
Jul 16, 2020 12:03 AM

3295 views | 3 replies
How to open 1st file and analyze it, then close and open the 2nd file, etc

Hi I have a jsl want to use and run many files in different folders, then save the file with a name.My solution is to put all the all the files path/directory into one excel file,then run the path from row 1 to end.There are 2 problems,1. How to read the path file and use it to open the csv data,2. How to save the file with a name that won't be overwritten, it can be the value of Column1,Row1, Can...
Stokes

Discussions |
Jul 15, 2020 11:29 PM

2216 views | 2 replies
Scatter plot x and y axis values

Hi All, i would like to replicate the following scatter plots in JMP, the problem i am having is when i go to axis setting and request a log scale with a base 2 the scale starts from 1, so the scales is 1,2,4,8,16, 32, 64 etc i would like it to start at 5, 10, 20,40, 80,160,320 etc does anyone have any advice?? Any help would be appreciated. Thanks
Mickyboy

Discussions |
Jul 15, 2020 5:04 PM

11315 views | 18 replies
Is there a way to display 95th, 90th 75th, 50th, 25th, 10th and 5th percentiles in box plots in graph builder or one way plots

In my work we display 95th, 90th 75th, 50th, 25th, 10th and 5th percentiles + the mean in our box plots in excel (which is painful and time consuming) – is there a way of replicating this in JMP oneway or graph builder? andrew.botfield@geochemistry.com.au
Andrew_Botfield

Discussions |
Jul 15, 2020 4:28 PM

6609 views | 8 replies
Get XML Elements

Hi, I am trying to read and XML file with a structure similar to the snippet below. <Top Element>
<Element 1>True</Element 1>
<Element 2>True</Element 2>
<Element 3>False</Element 3>
</Top Element> I know how to use the Parse XML by calling out the element names but in the document I have there are hundreds of different element names that I don't want to call out specifically in my code. I ...
Brandon

Discussions |
Jul 15, 2020 1:40 PM

2778 views | 3 replies

Previous
Next

Latest Discussions

Is there a way to display 95th, 90th 75th, 50th, 25th, 10th and 5th percentiles in box plots in graph builder or one way plots

In my work we display 95th, 90th 75th, 50th, 25th, 10th and 5th percentiles + the mean in our box plots in excel (which is painful and time consuming) – is there a way of replicating this in JMP oneway or graph builder? andrew.botfield@geochemistry.com.au
Andrew_Botfield

Discussions |
Jul 15, 2020 4:28 PM

6609 views | 8 replies
Get XML Elements

Hi, I am trying to read and XML file with a structure similar to the snippet below. <Top Element>
<Element 1>True</Element 1>
<Element 2>True</Element 2>
<Element 3>False</Element 3>
</Top Element> I know how to use the Parse XML by calling out the element names but in the document I have there are hundreds of different element names that I don't want to call out specifically in my code. I ...
Brandon

Discussions |
Jul 15, 2020 1:40 PM

2778 views | 3 replies
simple copy paste frm jmp to Excel not happening completely

HiHelp! Please let know if this is some kind of a bug: I just tried to do a super simple copy paste of 2000 cells in a column in jmp to Excel and only 1600 get pasted in ExcelThe same operation has no issue for other two columns where all 2000 cells get pasted.Thanks
kanchanjoshi

Discussions |
Jul 14, 2020 10:11 PM

3211 views | 3 replies
Getting my script to wait for platform to finish

Hi all Hope you can help me with a large problem, my scrip is making a new window with a report header, then the user is putting in the columns for analysis and click OK. From that analysis I make a "Combined Data Table" but it always fails because the scrip it not waiting for the platform to finish. So my report generation stops. I know the script works when I use a list for named columns or fo...
Jakob

Discussions |
Jul 14, 2020 7:39 AM

1751 views | 1 replies
Creating a New Column with Initial Sequence Data

I frequently concatenate multiple data tables into a single table and then add two new columns with initialized data. New Column 1 is called "Device" and is a constant that I enter. New Column 2 is called "Index" and is sequential data from 1 to x, where x is the last row in the data table. I would like to script the creation of these two new columns in the concatenated table, ideally with a Pop ...
toddsmith77

Discussions |
Jul 14, 2020 7:25 AM

4465 views | 4 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

1288 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

1308 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

4655 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

2206 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

2016 views | 0 replies