JMP User Community

Latest Discussions

5-4-4 fiscal calendar, col formula or jsl script

Has anyone written a column formula or script that will allow me to convert a date:time to a particular week or quarter in my company's OBSCURE fiscal calendar, known as the "5-4-4" fiscal calendar? I see google references to other fiscal calendars, but apparently the 5-4-4 is uncommon.
Devin

Discussions |
Oct 20, 2021 4:38 AM

2727 views | 4 replies
How to activate a button box with "desired script" from the text box.

As shown below, when the user inputs the desired script into the text box(ex. Distribution( Continuous Distribution( Column( :X) ) );)and then executes the button box, how can the corresponding script be executed as analysis? Thanks for letting us know! I want the script to be executed as analysis when the user inputs the desired script into the text box and then executes the button box as shown ...
jemg

Discussions |
Oct 19, 2021 6:04 PM

2078 views | 3 replies
put categories into the same cell with delimiter

Hi, I'm in tabulate and has the below table:Is there a way i can make the channel into one cell using existing function, not script? like:Thanks in advance!
joann

Discussions |
Oct 19, 2021 1:21 PM

1257 views | 3 replies
Case Insensitive searches

Hi,Most JMP is case insensitive except when it comes to text values.Since text data is often messy and case is one way it shows up, is there a way to do case insensitive versions of Contains?
Hegedus

Discussions |
Oct 19, 2021 12:15 PM

15246 views | 5 replies
newb question

Hello,Im recently learn about JMP. and i had a problem when i have the result of my analysis. the result is not significant enough. why this could happen? what the couses the result is not significant?
xowukoso

Discussions |
Oct 19, 2021 9:02 AM

1122 views | 3 replies

Previous
Next

Latest Discussions

put categories into the same cell with delimiter

Hi, I'm in tabulate and has the below table:Is there a way i can make the channel into one cell using existing function, not script? like:Thanks in advance!
joann

Discussions |
Oct 19, 2021 1:21 PM

1257 views | 3 replies
newb question

Hello,Im recently learn about JMP. and i had a problem when i have the result of my analysis. the result is not significant enough. why this could happen? what the couses the result is not significant?
xowukoso

Discussions |
Oct 19, 2021 9:02 AM

1122 views | 3 replies
Convert Character Datetime to numeric

I tried the formula scripts posted in other threads with no luck. How to convert timestamp in character to numeric datetime?
Pro_DF_2021

Discussions |
Oct 19, 2021 3:42 AM

1745 views | 1 replies
How to Get Difference Between Two Data Tables

Hi, I need some help figuring out difference details between two data tables. At a high level, if there is addition of new rows in New.jmp then I would like to save the new additions in a separate file. I am using Jmp 12.2 and have the following so far using Compare Data Tables but it only provides info on whether there is a add or delete... would like to take this one step further. If Compare Dat...
uProf

Discussions |
Oct 18, 2021 12:37 PM

2008 views | 2 replies
How do I compare differences between LS-means

Is there a way to compare the differences between the LS-means of several groups? In other words, how can I detect differences between the differences in different groups? If I run a linear model on my original data, I can use multiple comparisons to get the difference between the LS-mean of each group and the standard errors of those differences. Can I go a step further and do another test to see...
jeekhoff

Discussions |
Oct 18, 2021 10:17 AM

2382 views | 2 replies

Previous
Next

Latest Discussions

Preserving JMP Data Table Hyperlinks when Tables are Saved in Excel Format

At the risk of blasphemy, I am trying to figure out how to save a table that has hyperlinks for all data in a column in an Excel file, where the hyperlinks are still functional. I pull a lot of Excel data into JMP for faster data analysis and can add hyperlinks to entries in JMP columns. I can save the resulting charts as picture files and raw data files that can be read in Excel, but would also l...
JensRiege

Discussions |
Oct 15, 2021 3:39 PM

745 views | 0 replies
non-parametric response screening

I love the response screening platform. Is there a way to choose the fit y-by-x model to be non parametric, so i can compare non-normal distributions? is that the Huber/cauchy options?thanks
ezorlo

Discussions |
Oct 11, 2021 1:03 AM

608 views | 0 replies
JSL: Saving multiple chart and auto fit each of them into 1 page

I have created a Window with V List Box which contained multiple Variability Charts and tried to save them into 1 pdf. What i want to achieve is saving and auto scale each of the Variability Charts into 1 single page of pdf. Can anyone help to advise how to do that? Much appreciated!nw = New Window( "taskQueryCharzCurrent - Variability Chart of current", V List Box( Variability Chart( Y( :cu...
giin

Discussions |
Oct 7, 2021 6:42 AM

799 views | 0 replies
Skip Lot Sampling Plan

Hi,I am interested to use JMP for skip lot sampling plan. I like to test only a fraction (f) of samples after successful inspection of (n) number of samples. Here is the link to NIST https://www.itl.nist.gov/div898/handbook/pmc/section2/pmc27.htm I appreciate any help you can provide. Thanks Adam
AT

Discussions |
Sep 10, 2021 10:38 AM

941 views | 0 replies
Time values in xls or xlsx, csv, and JMP

Hi all, I have a strange issue with the time values from my excel. I have some data (example is attached here as excel file), the time column is an interest for me and I would add the date and time column together to create a date time column. To analyze the data, I use JMP so I am importing the excel file.However, I ran into a number of oddities:1. When I import multiple files (from customers to ...
fliew0410

Discussions |
Sep 7, 2021 7:25 AM

943 views | 0 replies