JMP User Community

Latest Discussions

Sort order in custom sort window

How does the JMP Sort window pass ascending and descending from the buttons to the Col List Box (ListBoxBox?) to the OK button? I need to make a custom sort window with limited options for data tables in a report. I figured out how to do most of it, either building up a sort window from scratch, or starting with the JMP sort window. An example with the latter follows. How do I get order_list == ?...
twalk

Discussions |
Oct 14, 2020 6:03 PM

1409 views | 1 replies
Importing Data to Jmp

Hi, I am developing a JMP analysis to periodically data. I have a excel macro that is generating a new CSV every week in a particular folder. I am still a very basic player with JMP, so wasnted community's support to help me build script to perform this activity. I did try to search around but didnt find any solution. The CSV file has 19 columns with header. I can eliminate header row from CSV if ...
NilD

Discussions |
Oct 14, 2020 9:57 AM

18092 views | 9 replies
convert a date from a number to date

so i have a jsl data table that has dates like this: 04/09/2020 2:59:17 AMwhen i save it to excel as xls file it saves it as 3675976666so when i open it again in jmp, its a number as above, how can I transfer it back to the way it was in line number 1?
itzikd

Discussions |
Oct 14, 2020 8:52 AM

2812 views | 1 replies
Using JSL to add reference lines to Page By graphs

I have a script where I use Page By to create a set of graphs. I want to add different reference lines to each graph, pulled from a list. Currently the only way I know how to specify which graphs to add the reference lines to is by referring to the graph by its integer index (which seems to start at 2) using ScaleBox. (Please let me know if there's a better way than using the integer index.) E.g.:...
markschwab

Discussions |
Oct 13, 2020 3:30 PM

4279 views | 1 replies
ANOVA vs. GLM for ecological field experiment

I am analyzing data from an ecological field experiment, designed to test the effects of herbivore (limpet) removal and moisture addition on change in cover of a rocky intertidal seaweed. The experimental design is a randomized block, two-factor full-factorial design. I have attached a document that details the experimental design and lists the scripts and model outputs relating to three questions...
cbhalpern

Discussions |
Oct 13, 2020 7:45 AM

12927 views | 18 replies

Previous
Next

Latest Discussions

Sort order in custom sort window

How does the JMP Sort window pass ascending and descending from the buttons to the Col List Box (ListBoxBox?) to the OK button? I need to make a custom sort window with limited options for data tables in a report. I figured out how to do most of it, either building up a sort window from scratch, or starting with the JMP sort window. An example with the latter follows. How do I get order_list == ?...
twalk

Discussions |
Oct 14, 2020 6:03 PM

1409 views | 1 replies
convert a date from a number to date

so i have a jsl data table that has dates like this: 04/09/2020 2:59:17 AMwhen i save it to excel as xls file it saves it as 3675976666so when i open it again in jmp, its a number as above, how can I transfer it back to the way it was in line number 1?
itzikd

Discussions |
Oct 14, 2020 8:52 AM

2812 views | 1 replies
Using JSL to add reference lines to Page By graphs

I have a script where I use Page By to create a set of graphs. I want to add different reference lines to each graph, pulled from a list. Currently the only way I know how to specify which graphs to add the reference lines to is by referring to the graph by its integer index (which seems to start at 2) using ScaleBox. (Please let me know if there's a better way than using the integer index.) E.g.:...
markschwab

Discussions |
Oct 13, 2020 3:30 PM

4279 views | 1 replies
ANOVA vs. GLM for ecological field experiment

I am analyzing data from an ecological field experiment, designed to test the effects of herbivore (limpet) removal and moisture addition on change in cover of a rocky intertidal seaweed. The experimental design is a randomized block, two-factor full-factorial design. I have attached a document that details the experimental design and lists the scripts and model outputs relating to three questions...
cbhalpern

Discussions |
Oct 13, 2020 7:45 AM

12927 views | 18 replies
How to use JMP script to auto generate a new summary table, quartile by group.

Kindly suggest How to use JMP script to auto generate a new summary table, quartile by group?To summarize quartile 90%, 75%, 25% by three combination group: BOX & Site & GOUP.thanks a lot. BOXSiteGroupValue602H0S140ID0030.246236602H0S140ID0050.042778602H0S140ID0070.983971602H0S140ID0080.119373602H0S140ID0090.843374602H0S1303ID0030.763462602H0S1303ID0050.407134602H0S1303ID0070.405919602H0S1303ID008...
qspringleaf

Discussions |
Oct 12, 2020 5:48 PM

1484 views | 1 replies

Previous
Next

Latest Discussions

Default encoding on JMP - EUC-KR

Hi,I have JMP 14.2, 15.1, and also 16.0EA at the moment.All versions here don't include EUC-KR encoding system; so this can cause importing problems in many cases since a lot of Korean data or pages are made with EUC-KR. I have charsets that are all broken. So I had to import it with other programs and save as to fit into UTF-8 or match/join columns with other matching codes.It seems like JMP is a...
joelahn

Discussions |
Sep 10, 2020 1:26 AM

1401 views | 0 replies
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

985 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

1098 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

1486 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

1690 views | 0 replies