JMP User Community

Latest Discussions

how to remove a local data filter column?

Hello, I have a problem that can be simplified to the following example: Names Default To Here( 1 ); dt = Open( "$SAMPLE_DATA/Cities.jmp" ); obj = dt << Data Filter( Add Filter( columns( :Region, :POP ) ) );Is there a way to remove :Region from the data filter without deleting the data filter and creating a new one? Thank you for your help!
newbie_alex

Discussions |
Aug 17, 2017 9:04 AM

5175 views | 1 replies
How do I calculate a ratio with negative numbers

Without using scripting, I want to create a formula that computes a ratio between two columns of CAGR percentages, taking into account that some of the percentages are negative (meaning simple division will not suffice). A formula that might accomplish this is:If the above formula would work, how would I incorporate the comma in the JMP formula box? Or, is there a better way to compute the ratio?
rj69

Discussions |
Aug 16, 2017 12:51 PM

17261 views | 2 replies
Run VBA code in JSL script

Hello all! I'm new to JMP. I've seen many post claiming that it is possible to run a JSL script via Excel VBA. I was wondering if the other way around is possible. Run VBA code inside a JSL script. Reason: I have a macro in Excel and a script in JMP. I would have liked to bring the excel macro to my JMP script. Thanks for info!
Eduardo

Discussions |
Aug 16, 2017 11:42 AM

7236 views | 2 replies
Applying DOE at the Bench

I am still relatively new to the world of DOE and using JMP. I have to say that I am a convert on the utility of DOE, but I have had an incredibly hard time finding materials that actually walk you through application of DOE for assay development, or more real world applications in the laboratory. I think one of the main reasons it is not adopted more rapidly is due to the lack of pragmatic an...
frportell0

Discussions |
Aug 16, 2017 10:02 AM

9678 views | 6 replies
Scaling a window to be saved as a PDF?

Hey JMP Community I am new to JSL, and have been working on a script for the past week or so. The final portion of the script is supposed to take a graph and save it as a PDF. The issue I am having is that I cannot seem to find a way to scale this PDF down to one page. I can do this manually by clicking "Save As" in the graph window, choosing the PDF file format, and setting the scale to 80%. Curr...
michaelgroom

Discussions |
Aug 16, 2017 9:25 AM

9547 views | 4 replies

Previous
Next

Latest Discussions

Scaling a window to be saved as a PDF?

Hey JMP Community I am new to JSL, and have been working on a script for the past week or so. The final portion of the script is supposed to take a graph and save it as a PDF. The issue I am having is that I cannot seem to find a way to scale this PDF down to one page. I can do this manually by clicking "Save As" in the graph window, choosing the PDF file format, and setting the scale to 80%. Curr...
michaelgroom

Discussions |
Aug 16, 2017 9:25 AM

9547 views | 4 replies
MANOVA Partial Covariance Matrix

Hello, I am getting familiar with JMP's Fit Model platform by trying to match results with MATLAB and MS Excel long-hand that I have computed. Using the "Cholesterol.jmp" sample data file and running the Fit Model platform with MANOVA personality, I was a bit confused as to why my Partial Covariance matrix did not identically match my Covariance Matrices in MATLAB and MS Excel. Here is the JMP ou...
bio_grad

Discussions |
Aug 14, 2017 8:02 PM

7218 views | 3 replies
Graph Builder: Convert x-axis label from horizontal to vertical

Hello, I'm using Graph Builder (JMP 10) to group 3 items (WAT date, Lot#, and Wfr ID) on the same x-axis. In the attachment, only Wfr ID is vertical. Is there any way I can convert the horizontal labels of WAT data and Lot# to vertical ones for a clearer visualization? Thank you! Best,Han
ngochanle2210

Discussions |
Aug 14, 2017 1:25 PM

4031 views | 1 replies
Transfer columns with values to a new table

Please will you help me with this script. I'm trying to transfer a column full of items/values (some characters and Numerics) from an old table to a new table and this scripts is not fully working. I'm propably missing something. I'm sorry I'm new to JMP. DATAtwo=Data Table("Results Extract");testid = DATAtwo:column3 << Get Values; // Testtrans =Column(testid);　dtfour << New Column( "key", formula...
IrisK

Discussions |
Aug 12, 2017 6:47 AM

7497 views | 2 replies
Confidence intervals in prediction profiler (interpretation)

Hi Could you help me please? I am still learning DOE. How can I interpret confidence intervals in the prediction profiler?So there are significant effects and interactions. However when "discount" is 0 and "direct_comm" is 1 the difference is not significant (picture below)? So how may I interpret another case when CI of "discount" are significant but CI of "direct_comm" are not? The remaining: ...
gustavjung

Discussions |
Aug 12, 2017 4:57 AM

3657 views | 1 replies

Previous
Next

Latest Discussions

JSL How do I wrap the title text of a OutlineBox?

Hi all, I often use the Set Title() message to overwrite the OutlineBox titles of charts, distributions, etc. My first issue is that the OutlineBox does not support the Set Wrap() message. Is there any replacement I could use? To work around the missing Set Wrap(), I started inserting newlines "\!n" in the tiitle text. After doing this, I have noticed a second issue: Whatever number of newlines I ...
AlexanderKrebs

Discussions |
Jun 13, 2017 5:38 AM

4121 views | 0 replies
Printing worksheet with cell colors

Hello JMP Community, I'm currently using JMP version 10.0.0 and having trouble printing my data table with cells highlighted in certain colors. Is there a way to print keeping the colors or to even export the file keeping the cells highlighted?

Thanks.
ferdt58

Discussions |
May 16, 2017 9:14 AM

2014 views | 0 replies
Linearity and Bias Report

In Our MSA stsudy we are performing Linearity and Bias measurment. We are currently controlling at Linearity and Bias to be below 5%. We actually generate the following report for Linearity and BIas. However in AIAG handbook the criteria for the gauge to pass bias criteria has the following criteria.
Aravindan

Discussions |
Apr 18, 2017 12:54 AM

4020 views | 0 replies
CCC Optimal

Hi,I have 2 clustering chooses as mentionned below,- Nr of cluster 15 : CCC = 69.99 (OPTIMAL)- Nr of cluster 15 : CCC = -92.87- Nr of cluster 15 : CCC = -112.8 The first one with CCC = 69.99 is mentionned as the best optimal. I don't understand why this one is the best by consedering the different values ?. What is the signification of these values ? Thanks,
Lamine

Discussions |
Mar 17, 2017 5:25 AM

3125 views | 0 replies
Understanding the Dispatch and Legend Model and what exactly is Base(0,0,0)?

My problem is two fold. Im writing a JSL Function to create some custom charts at work. Everything is working fine. Thats great. But I dont understand why - and I am trying to break down the code. Most of I wrote myself, but some aspects I made the tweaks within JMP, copied the scripts and used the parts that generated what I needed. Some of the code chunks that get added in are intuitive to read ...
kevinwtbolger

Discussions |
Feb 26, 2017 9:30 AM

3128 views | 0 replies