JMP User Community

Latest Discussions

Create m/y column from separate character month and year columns

How do I create a date column with format yyyymm or m/y from two character columns entitled Month and Year? This data is imported from city water billing system as a text file. See attached example. I know how to concatenate the columns into another character column, but we will need the output column formatted as a date column to perform frequency calculations.
Dukowitz62

Discussions |
Aug 17, 2021 5:28 PM

2183 views | 2 replies
Applying Boolean Logic to filtering/selecting records in a Dashboard/Application built from multiple platforms

Hi everyone, I've been working on a systematic map to accompany a literature review on forest bird habitat relationships that is getting much closer to completion. A hearty shout out to community members @cwillden , @txnelson , @danschikore , @brady_brady , and technical support crew Adam Morris, Sarah Seligman, Laura Archer, and Wendy Murphrey for helping me get this project this far along. I f...
caseylott

Discussions |
Aug 17, 2021 11:15 AM

1217 views | 0 replies
change size axis increments based on time

I am plotting data over time using an uneven spread of intervals (1 week, 2 weeks, 1 month, 6 months, etc). I would like to make it so the increments on the x axis are sized proportionally to the amount of time; 0-1 weeks, 1-2 weeks being the smallest and 6-9 months, 9-12 months being the largest.
ohaynes

Discussions |
Aug 17, 2021 9:42 AM

2565 views | 6 replies
Set desirability - Maximize desirability VS Simulation experiments

Hi there,I need your support please to find the optimal conditions which allow having the highest Y1 (yield) while keeping Y2 (impurities) lower than 70.Both responses have equal importance.I’ve tried with “maximize desirability” after setting desirability. When we set desirability, we have 4 options (maximize, minimize, target and none).For Y1: I’ve selected “Maximize”For Y2: I am left with the o...
JMPdiscoverer

Discussions |
Aug 17, 2021 8:01 AM

1309 views | 2 replies
Set Property for Missing Data

Quite certain this is a simple fix for those in the "know" however, i have been struggling to figure it out. I have a pass_fail column when i am doing my limits and need to figure out how to assign "Fail" to missing data.I use the same table to plot distributions so assigning a random number to the missing data could cause problems. Thanks in Advance Column( dt_split, N Cols( dt_split ) ) << Set P...
Yngeinstn

Discussions |
Aug 17, 2021 4:33 AM

1306 views | 2 replies

Previous
Next

Latest Discussions

Applying Boolean Logic to filtering/selecting records in a Dashboard/Application built from multiple platforms

Hi everyone, I've been working on a systematic map to accompany a literature review on forest bird habitat relationships that is getting much closer to completion. A hearty shout out to community members @cwillden , @txnelson , @danschikore , @brady_brady , and technical support crew Adam Morris, Sarah Seligman, Laura Archer, and Wendy Murphrey for helping me get this project this far along. I f...
caseylott

Discussions |
Aug 17, 2021 11:15 AM

1217 views | 0 replies
Set desirability - Maximize desirability VS Simulation experiments

Hi there,I need your support please to find the optimal conditions which allow having the highest Y1 (yield) while keeping Y2 (impurities) lower than 70.Both responses have equal importance.I’ve tried with “maximize desirability” after setting desirability. When we set desirability, we have 4 options (maximize, minimize, target and none).For Y1: I’ve selected “Maximize”For Y2: I am left with the o...
JMPdiscoverer

Discussions |
Aug 17, 2021 8:01 AM

1309 views | 2 replies
Set Property for Missing Data

Quite certain this is a simple fix for those in the "know" however, i have been struggling to figure it out. I have a pass_fail column when i am doing my limits and need to figure out how to assign "Fail" to missing data.I use the same table to plot distributions so assigning a random number to the missing data could cause problems. Thanks in Advance Column( dt_split, N Cols( dt_split ) ) << Set P...
Yngeinstn

Discussions |
Aug 17, 2021 4:33 AM

1306 views | 2 replies
Gentle Introduction to Application Builder

I wanted to share some materials I presented recently to my local regional JMP User's Group in Phoenix about getting started with Application Builder. The first time I opened Application Builder back in JMP 10, I got frustrated very quickly. It wasn't until I took a course from JMP on the subject that I was able to really do anything with it. Since then, I have developed all my JMP applications...
cwillden

Discussions |
Aug 16, 2021 1:34 PM

9897 views | 5 replies
jsl script individually working fine, but add-in implementation is not working

I have a data table where I want to replace certain values with "."
Below is the script example dt = Current Data Table(); for each row ( if (:age == 12, age= . ); );but same is not working when I have this code as add-in, data table looks like thisvinay 35 atul 55 prerna 12 adi 21Thanks,Sibh
SIBH

Discussions |
Aug 16, 2021 1:30 PM

1286 views | 2 replies

Previous
Next

Latest Discussions

Applying Boolean Logic to filtering/selecting records in a Dashboard/Application built from multiple platforms

Hi everyone, I've been working on a systematic map to accompany a literature review on forest bird habitat relationships that is getting much closer to completion. A hearty shout out to community members @cwillden , @txnelson , @danschikore , @brady_brady , and technical support crew Adam Morris, Sarah Seligman, Laura Archer, and Wendy Murphrey for helping me get this project this far along. I f...
caseylott

Discussions |
Aug 17, 2021 11:15 AM

1217 views | 0 replies
Projects Window List in JMP 15 for Mac -- Reorder?

I'm trying to use JMP projects more with the promise of re-using graphs and analyses on new sets of similar data. I'm using the Window List in the UL as a kind of 'table of contents' that I can click into to see/show my findings for various analyses. There is a flow to the findings which I'd like to order in that Window List. Is this possible? I can't click and drag an entry for a window up or d...
datanaut

Discussions |
Aug 16, 2021 6:38 AM

611 views | 0 replies
请问JMP有哪些模型可以用于预测股票价格的未来走势？

这是个异想天开的问题: 大家都说股票价格的未来走势预测是艺术、不是科学。
但我还是想看看JMP具体哪里模型能用于这方面。我尝试过使用决策树、随机森林、xgboost。
还使用了DOE制作了均匀试验表来进行分类统计。
虽然这不是一个很好的问题、但还是非常期待专家们的回答。非常感谢！
lala

Discussions |
Aug 2, 2021 1:01 AM

704 views | 0 replies
Categorizing term lists for Word Cloud display and/or filtering

Hi all, I have a word cloud based on unstructured text from journal articles. Many of these terms fall into common categories, e.g.: 1) tree species, 2) bird species, or 3) geographic locations. Many of these grouped terms are relevant to my user group, but difficult to locate amongst the large number of terms in my corpus (particularly when uncommon terms don't show up in the Word cloud). I was w...
caseylott

Discussions |
Jul 29, 2021 12:32 PM

896 views | 0 replies
Partial redundancy analysis in JMP

I need to check the effects of three explanatory variables which are 1) fish_length, location, and sex on a set of response variables (PC1…..PC7).
First I need to test the effect of size (fish size), and in case if the effect of fish_length is significant then I need to use the residuals of the first pRDA test to check the effects of location and sex using RDA. Also I will need to use the residuals...
ukhandurrani

Discussions |
Jul 22, 2021 9:33 AM

1253 views | 0 replies