JMP User Community

Latest Discussions

Data Table sort by two columns

Normally data table can sort order by one column, just have left table shows, sort by column "Name".but how to use JMP to sort by two column? order by both "Name" & 'Date", like the right table shows, kindly help to suggest. thanks a lot. NameDateAccomplish amounts of work-->NameDateAccomplish amounts of workJohn20/8/21 9:03:59100%Kevin20/8/17 9:03:5760%Kevin20/8/22 9:03:5980%Kevin20/8/18 9:03:574...
qspringleaf

Discussions |
Aug 24, 2020 9:11 PM

2666 views | 1 replies
categorical response analysis report show percentage of response for each response value

Under categorical response analysis report, how can I show percentage of response for each response value. For example (see the report below), how to include percentage of response for each preference group (1, 2, or 3), i.e. calculate column-wise percentage. Thanks.
eijoac

Discussions |
Aug 24, 2020 11:08 AM

2246 views | 5 replies
Adding a Value to End of Trend Line

I have a set marker at 1800 RFh and my trend line shows that at the end of this reporting period, I have cross and passed the mark.However, how can I add a value at the end of the trend line to show the calculated value by JMP? Assuming Lamda is default.
Sage

Discussions |
Aug 24, 2020 9:24 AM

2081 views | 3 replies
Which Run order I have to choose for my DoE?

Hello,I want to perform a DoE in order to optimize an extraction method. My plan is to start with a screening of the main factors using Plackett Burman followed by a central composite design in order to do a response surface. Before making a Design tube I should choose a Run order (sort left to right, sort right to left, randomize...) and I do not know which run order I should choose for each of m...
ELH

Discussions |
Aug 24, 2020 5:00 AM

3999 views | 11 replies
JSL, Remove duplicate rows by looking at another column condition.

Hello again,
I am looking to remove duplicate rows by looking at another column condition.
I want JSL to remove the duplicate "Roi" rows when they appear in the same Date and keep only the latest row by time (on Date and time column) so the end result will be table with only rows 1,2,3,4 and rows 5 and 6 that appear with same date as row 4 but the time is earlier will be deleted. RowDate and timeNa...
ileshem

Discussions |
Aug 23, 2020 2:18 PM

1824 views | 1 replies

Previous
Next

Latest Discussions

Data Table sort by two columns

Normally data table can sort order by one column, just have left table shows, sort by column "Name".but how to use JMP to sort by two column? order by both "Name" & 'Date", like the right table shows, kindly help to suggest. thanks a lot. NameDateAccomplish amounts of work-->NameDateAccomplish amounts of workJohn20/8/21 9:03:59100%Kevin20/8/17 9:03:5760%Kevin20/8/22 9:03:5980%Kevin20/8/18 9:03:574...
qspringleaf

Discussions |
Aug 24, 2020 9:11 PM

2666 views | 1 replies
Which Run order I have to choose for my DoE?

Hello,I want to perform a DoE in order to optimize an extraction method. My plan is to start with a screening of the main factors using Plackett Burman followed by a central composite design in order to do a response surface. Before making a Design tube I should choose a Run order (sort left to right, sort right to left, randomize...) and I do not know which run order I should choose for each of m...
ELH

Discussions |
Aug 24, 2020 5:00 AM

3999 views | 11 replies
Adding DATE properties to a column in JSL

Hi All,I know we can add DATE stamp to any column in JMP for a time trend as following:right click on any column-> choose column info->Column properties->Other->Type in "DATE" ->Insert the name of column including the dates Is there a script to do that automatically? Thanks a lot!Moe
mjafari

Discussions |
Aug 23, 2020 1:44 PM

910 views | 1 replies
confusion matrix and performance meassures

At present in JMPpro, the only performance meassure automatic calculated from the confusion matrix from a model is the misclassification rate and eventually the AUC of the ROC. Other meassures such as Fase positive and False negative rates, sensitivity , specificity, negative and positive predictive value, precision/recall (= F1-score) and MCC are commonly described in ML literature and are very ...
Lu

Discussions |
Aug 22, 2020 9:55 AM

2964 views | 1 replies
merge table from 2 csv files

Hi, I have two csv files (round1.csv & round2.csv). How can I merge into a new table mergeRound.csv. I was trying to play around with the Last Name,First Name,Number combine should be the same. The rest of the columns should be merge. I was playing around the Tables menu but cannot figure it out before putting it to JSL. Thanks.
sam_t

Discussions |
Aug 22, 2020 3:42 AM

2936 views | 3 replies

Previous
Next

Latest Discussions

order statistic for DS Weibull ... maximum failure time for n fails out of N~n/p units

this isn't a JMP question per se, but a reliability/survival statistics question ... see my post on Cross Validatedthanks in advance! https://stats.stackexchange.com/questions/483556/order-statistic-maximum-for-subpopulation-weibull-distribution
galactus3000

Discussions |
Aug 18, 2020 8:48 AM

720 views | 0 replies
Custom Lat Long Contour Map

Hi all, Playing around with the Custom Map Creator add in and I ran into some trouble when trying to construct borders for a river system. When constructing a custom map border using a a background map the boundaries function does not let me to trace the river pattern as accurately as I would hope (see attached photo). Alternatively, when constructing a border from a background photo the bounda...
MikeDereviankin

Discussions |
Aug 14, 2020 11:03 AM

804 views | 0 replies
XPath Query() and XML namespaces

I have a bunch of XML documents that I want to put into a data column. I want to use XPath expressions to pull out values from them, by appending columns that contain formulas that make use of the XPath Query() function. Some of my documents have XML-namespace qualified element names. For example, one might look like this: <?xml version="1.0" encoding="UTF-8"?> <synopsis xmlns="http://www.cap.org/...
john_madden

Discussions |
Jul 23, 2020 9:53 AM

976 views | 0 replies
Using JMP to Calculate Surface Flatness

Has anyone used JMP to calculate the Minimum Zone surface flatness of a point cloud? I have some differences between two metrology areas for our surface flatness requirements and wanted to check them in JMP. There are different algorithms for doing the calculation. (There is an ASME standard for the general rule, ASME Y14.5: " a tolerance zone defined by two parallel planes within which the surfa...
jay_holavarri

Discussions |
Jul 20, 2020 11:26 AM

1271 views | 0 replies
Save all scripts and close reports by JSL

Trying to write a script for this I found the following below working. JMP15@Win10.The first part opens two tables and starts some Reports,and the second Closes all report Windows post saving scripts to belonging tables.But when the report has a local datafilter, the script is not working any more (get scriptable object doesn't get the Right reference).Is there a way to find proper reference for e...
Georg

Discussions |
Jul 20, 2020 7:48 AM

1123 views | 0 replies