JMP User Community

Latest Discussions

overlay color issue on graph builder

Hi All, I tried to plot a bunch of graphs on graph builder with PASS(gray) and Fail(Red) color. Values are such a way that the data points are on top of each other. When I hover on it, it perfectly shows the specific row that failed. But when I try to convert this graph into interactive html, the hovering function points to the "PASS" data beneath the fail data points. Is there any way that I can ...
vishwasanj

Discussions |
Apr 20, 2020 9:21 AM

16873 views | 9 replies
Application with Multiple Data Table and will not create local data filters correctly

Hello all, I am trying to make an application that references multiple data tables, and within that application there are data filters that apply to graphs from each data table. When I insert the local data filter, the column options are correct. However, when I run the application all of the local data filters will reference whichever data table I had open last. Both say they are referencing the ...
DopeAgonist

Discussions |
Apr 20, 2020 9:07 AM

9755 views | 5 replies
filter with date

Hi, In a dashboard, I have a filter with week numbers which applies to graphs. HHow to do in the script to have a selection of weeks which is updated from the last 3 weeks from today's date ans would be automatic? best regards
Françoise

Discussions |
Apr 20, 2020 8:17 AM

2479 views | 2 replies
Find and Delete all formulas present in a table

Hi,I have 1000 columns in a table with 500 columns have formulas. I want to write a jsl script which will find the column having formula and delete the formula. One line code is highly recommended. Thanks :)
Rajat

Discussions |
Apr 19, 2020 11:02 AM

2241 views | 1 replies
how to achieve this type of graph with symmetrical distribution of points?

i was playing with the Graph Builder and i can't achieve the desired result (right graph on fig. 1) - i think it's a dot plot for distribution. the one given by Graph Builder is the one on the left - with jittered points. i unchecked the jitter checkbox but all the data points were all lined-up at the center (fig. 2).is there a way to achieve the right graph on fig. 1 in JMP?
appreciate the help.- ...
rabelardo

Discussions |
Apr 19, 2020 7:45 AM

14742 views | 6 replies

Previous
Next

Latest Discussions

Multiple file import update data table in place

Hey,I'm using MFI to concatenate multiple .csv files from folder(folder gets new files dropped in it every day) for analyzing data in JMP. I have also prepared couple scripts for analysis and data cleanup but my problem is that every time I run script for MFI it opens up a new data table without my prepared scripts for analysis :(I wonder what is the way right way to update my current data table i...
morussk

Discussions |
Apr 17, 2020 9:36 AM

4457 views | 6 replies
DOE to test taster's ability to predict color of candy (for kids)

Dear JMP & Community, During this time of being stuck at home with kids and working on school projects, I thought of running a "taste test" with my son who recently claimed that he could tell the color of a chocolate candy based on the color of the candy shell (it's a candy similar to that of M&M). I'm not entirely sure how to set up the DOE because it doesn't quite fall under Choice or MaxDif...
SDF1

Discussions |
Apr 17, 2020 7:59 AM

7469 views | 11 replies
how to use contains within match?

I have some text in a listA.I want to create another listB based on the value in listA.If the listA text contains apple then list B should be fruit;if list A has tomato listB should be vegetable;if listA has daisy listB should be flower.If none of these match then listB should have unknown.Also search needs to be case insensitive. Looking for something equivalent to case statement in JMP.I'm explo...
ENTHU

Discussions |
Apr 17, 2020 5:43 AM

4351 views | 6 replies
Bezier interpolation

Hi, Is there a function to plot Bezier interpolation?
mitulshah

Discussions |
Apr 16, 2020 6:38 PM

8383 views | 11 replies
How to analyze the weather pattern data?

I wanted to know whether due to climate change, the precipitation in the last 16 years (2004 to 2019) had changed from the previous 15 years (1989 to 2003). Our hypothesis is that the weather patterns has changed and precipitation in the last 16 years had increased. Here is the annual average data for different years. Year Precipitation (mm) 1989 384 1990 446 1991 471 1992 491 1993 507...
manphoolfageria

Discussions |
Apr 16, 2020 7:06 AM

2475 views | 1 replies

Previous
Next

Latest Discussions

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
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