JMP User Community

Latest Discussions

Using Max Date to Query

Hello,I have a file that is updated weekly based on the Max Date in the date column. Each week I open the file, look at the Max Date currently and then query data that is after the Max Date. Would it be possible to just pull the Max Date out and have it inserted into the query that I am using? Currently my file is updated to 8/15/2019 and I would like to query data that is > 8/15/2019 to update th...
Sully

Discussions |
Jan 28, 2020 7:54 AM

9950 views | 9 replies
Select Where Duration Is Greater Than

Hello, I'm trying to select rows where duration is greater than 1 sec. When I try to do this rows that show a duration of 1 sec are getting selected as well. What am I missing? Sample data table attached if needed. Details of what I'm trying to accomplishWe have data that is recorded every second. I was trying to check if there were any gaps or periods that were not recorded.Currently trying to ...
Herrera5238

Discussions |
Jan 28, 2020 6:24 AM

4436 views | 4 replies
Cannot subscript Display Box error

I have a custom script, but am seeing an error that says “Cannot subscript Display Box in access or evaluation of Report(dis)[Outline Box(6)]". Is there anyone who can help?
RobRobeyns

Discussions |
Jan 28, 2020 6:00 AM

3737 views | 2 replies
Factor constraints in custom design

I am using custom design with 3 continuous factors and I am trying to add factor constraint that X1 cannot be greater than X2. I tried using option 'Use disallowed combination filter' but it gives me setting for X1 in decimals (eg. 350.9811). Data table is attached. Is this the correct way to add this type of constraint?
billi

Discussions |
Jan 28, 2020 5:53 AM

4199 views | 5 replies
Round Robin - Tool to Tool matching - Matched pairs

Hello together,I am intrested in what statistical methods you would use to compare same items on different tools and sites? Purpose of the study is to define a specification limit. Repeated measurements are not planned as the repeatability of those tools are quite good (Showed by GRR). Still there are deviations within this tool group related to drift and calibration standards. I was thinking to c...
Martin91

Discussions |
Jan 28, 2020 4:38 AM

3713 views | 4 replies

Previous
Next

Latest Discussions

Round Robin - Tool to Tool matching - Matched pairs

Hello together,I am intrested in what statistical methods you would use to compare same items on different tools and sites? Purpose of the study is to define a specification limit. Repeated measurements are not planned as the repeatability of those tools are quite good (Showed by GRR). Still there are deviations within this tool group related to drift and calibration standards. I was thinking to c...
Martin91

Discussions |
Jan 28, 2020 4:38 AM

3713 views | 4 replies
Empty cells being counted in box plots

Hi,I am fairly New to JMP so forgive me if this is a bit basic! I have data from 32 individuals. I have recorded numerous parameters for each individual but could only measure one of the parameters in 24 of them. In the Box plot for this parameter n = 32 so it appears to be including the empty cells. Do I have have to go through and manually exclude rows where the cell for that specific parameter...
Harj

Discussions |
Jan 27, 2020 11:06 AM

2921 views | 4 replies
Control the graph, chart size in each New Window Tab.

Hi all, I have a problem with graph size in each tab of the new window. I have multiple tabs in a new window and the last tab contents a multiple vertical distribution chart (10 or more) enclose in a VListBox() function. The distribution chart are quite long in size and whenever I clicked to other tabs the graph in these tab seem to be stretched as the length of the distribution chart. Is there a...
Black_Wheel

Discussions |
Jan 27, 2020 6:06 AM

2930 views | 2 replies
Hide and exclude marked rows

I want to hide and exclude specific rows that I have marked with a certain symbol or color. These rows are scattered throughout my data set and I don't want to manually hide and exclude all of them. I also want to be able to reverse the hide and exclude function for the specific cells in order to compare my original and edited data. Does anyone have tips on what I should do?
ascaniop

Discussions |
Jan 24, 2020 5:28 PM

2463 views | 2 replies
Stacked Bar Graph Bar Width

Hello,

I am having issues increasing the size of the bars in my stacked bar graph. I would just like the bars to be a little wider for better visibility. I am plotting the data (see attached screen shot) by week for the year 2019. I am assuming that my bars are as thin as they are because I am trying to graph 8 different variables for each week but since some are blank and the graph is "stacked" I ...
nqueiss

Discussions |
Jan 24, 2020 1:46 PM

8369 views | 6 replies

Previous
Next

Latest Discussions

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
Running script from command line on MAC

Not a mac person. Does anyone know how to run a jsl script from command line on a mac? I specifically mean WITHOUT "//!" at the top of it. I have this but it only opens the file unless I have the "//!" open -g -W -a /Applications/JMP\ Pro\ 15.app/ $(pwd)/myscript.jsl
vince_faller

Discussions |
Jan 10, 2020 2:26 PM

1660 views | 0 replies
how to add confounding variable

I am working with a multi level data. Data is attached.In this dataset, I have 8- X variable: cumulative risk (continuous), all other risk (dichotomous). 3- Y variables: insurance and practice (dichotomous) and time (continuous)I have one confounding variable Age (continuous). I will have to add random effect to X variable. But I am confused how to add confounding variable to this analysis. Can an...
billi

Discussions |
Jan 6, 2020 9:39 AM

1600 views | 0 replies
Difference between std error in "Parameter Estimates" and "Least Squares Means Table"?

I am running mixed effects models and have noticed that the standard error for an effect in the "Parameter Estimates" table is different from the standard error reported in the Least Squares Means table for the same effect. How are they calculated differently? Thanks!
Ranae

Discussions |
Nov 26, 2019 11:44 AM

1681 views | 0 replies
How can I run a .py python script and python scripts compiled as .exe from JMP

Hello, So I've written a JMP UI, and once I gather data from the user I have a button that dumps the form data to a CSV.Now I need to launch my python script and other .exe (as an administrator), my python scripts pick up the user input from the CSV and perform the next steps.Right now it's a .py but I may need to run it through py2exe and compile it into an exe later so a solution that supports...
xxvvcczz

Discussions |
Oct 30, 2019 6:44 PM

2077 views | 0 replies