JMP User Community

Latest Discussions

how to calculate the number of times a text/number appears across several columns

hi, I have a need to calculate how many times a text/number appears in several columns. I was thinking to get all the numbers into a list and then use some function but I did not find the function I wanted. The data example is attached and I wanted to count how many time a number is repeated cross column 0.76, to column 1.0 in same row. Could anyone help me out on this? Thanks in advance!
robust1972

Discussions |
Jul 22, 2020 7:48 AM

20280 views | 9 replies
how do i create a summary table with means and the signifcantly different letters ?

HelloI use jmp to analyze experiments and than i need to show the means in a summary table with the signifcantly different letters (using one of the compare means test such as student t or tukey kramer)i don't know how to do it in one table with jmp so what i do is to export each table (for each parameter separately) to excel and than sort it out there but it takes a lot of timeis there a way to d...
LiG

Discussions |
Jul 22, 2020 5:36 AM

4146 views | 3 replies
How to combine/recode two columns?

I want to combine 2 columns. Suppose in sample library, big class example.I want a new column which is combination of two columns "sex" and "age". The resulting column should have rows in form F12, M12 etc. I tried with to combine columns using utility>combine but it gives error. Thanks for your help
sanqub

Discussions |
Jul 22, 2020 4:56 AM

29122 views | 6 replies
How can the minimum value of the specified column corresponding to each category be greater than the number of categories of a certain value?

For example, according to "Big class.jMP"
1. First, categorize by age.
2. Determine the minimum "weight" >90 for each age.
3. Figure out the number of age categories that meet the second condition.So it turns out the number of ages is 3. How can I use JSL to solve it quickly?Thanks!
lwx228

Discussions |
Jul 22, 2020 3:25 AM

2145 views | 3 replies
Combining values of multiple columns into one column

I have a data set where I would like to merge four columns into one column, so thatthe values of the four columns are displayed in one column. However, I have no clue how to do that.I have four conditions, which respondents have been exposed to depending on the day of the monththey are born. If a respondent has been exposed to Condition 1 it shows a 1 and the same forconditions 2,3, and 4. How ca...
nikolaj

Discussions |
Jul 22, 2020 3:24 AM

24775 views | 5 replies

Previous
Next

Latest Discussions

How can the minimum value of the specified column corresponding to each category be greater than the number of categories of a certain value?

For example, according to "Big class.jMP"
1. First, categorize by age.
2. Determine the minimum "weight" >90 for each age.
3. Figure out the number of age categories that meet the second condition.So it turns out the number of ages is 3. How can I use JSL to solve it quickly?Thanks!
lwx228

Discussions |
Jul 22, 2020 3:25 AM

2145 views | 3 replies
Autocorrelation by JMP14

I check my training powerpoint file I was trained on year 2007. When we want to make control chart, we have to check normality of data. And also autocorrelation by JMP. I try to search autocorrelation check on JMP14 but I cannot find it. Any function in JMP14 to use instead of autocorrelation.

In the previous version of JMP we need to go by Autocorrelation Check – In JMP:Analyze > Modeling > Tim...
ThoYala

Discussions |
Jul 21, 2020 10:38 PM

4840 views | 3 replies
Details about robust standard deviation from "Distribution" module?

The JMP documents guide me to the book by Huber & Ronchetti (2009). But it's still not clear for me how to calculate the robust standard deviation.Thanks!
jennyli

Discussions |
Jul 21, 2020 12:10 PM

5709 views | 3 replies
How to access System Preferences in JSL, specifically the date format setting

I've searched around and haven't found any simple way to get System Preferences settings from within JSL. I'm developing on a Mac – (JMP 14 & 15) – but would also like to know how to do this on Windows. The closest I got was a discussion on how to get the language code: System Service( Get Language Code );System Service sounds like and interesting function, but I couldn't find any documentation ...
SteveTerry

Discussions |
Jul 21, 2020 11:21 AM

2048 views | 1 replies
Selection Filter Not Interactive in HTML (trying to use Dashboards Offline)

Hello,I am using JMP 15 and trying to generate an interactive HTML Dashboard using a simple graph as a filter. I did this from the Dashboard builder using the "Filter +1 dashboard" template. Everything is working fine within JMP, however, when I attempt to save as interactive HTML with Data I get a message saying that interactive HTML is only partially applied. The log file states that selection...
CBroomell

Discussions |
Jul 21, 2020 11:04 AM

2340 views | 2 replies

Previous
Next

Latest Discussions

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

1733 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

1456 views | 0 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

1326 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

1347 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

4781 views | 0 replies