JMP User Community

Latest Discussions

weekly report with SQLquery tables

I have 3 SQLQuery tables generated. Few questions:To generate a weekly report, what’s the best way to store them, so next week once I have updated data, I can replace the data source once, and then the 3 query tables run automatically? Is it like journal, project, or dashboard?How to combine the scripts of the 3 query tables in order to run them all at once with updated data? I saw in each table t...
joann

Discussions |
Mar 4, 2021 1:27 PM

2575 views | 2 replies
Embed a JMP platform dialog into a new window()

Is there a way to embed part of a JMP built in platform dialog into a new window(). In this case specificaly I would like to embed the construct model effects window from fit model into a custom script:
pauldeen

Discussions |
Mar 4, 2021 11:19 AM

2476 views | 4 replies
Incorrect output for cross-correlation in time series platform?

Hi JMP Community,(W10, 64-bit, JMP Pro 15.2.1) I'm hoping to find out either what I'm doing wrong, or what I misunderstand about how JMP performs the cross-correlation calculations in the Time Series platform. In short, when I compare the cross correlation of a Sin(x) with a Cos(x) function, I don't get an answer of pi/2 (or 90-degree) as I would expect, I get 79-degrees instead. I am trying t...
SDF1

Discussions |
Mar 4, 2021 8:23 AM

4183 views | 6 replies
Value label not preserved in journal

I have a script that uses the bivariate platform to produce a plot of data over discrete time units (e.g. 202101 for 1st week of 2021). The time units used are not negotiable and do not space correctly if treated as continuous: the distance between 202052 and 202101 will not be the same as the distance between 202101 and 202102, but these distances should be the same as they are consecutive weeks....
drew_baumgartel

Discussions |
Mar 4, 2021 5:11 AM

2869 views | 4 replies
How to automate variability chart plotting?

I have a table with following information.I have this data for ~40 different tests and upper and lower limit are different for each of the test.How can I automate the variability chart plotting?part_numtest_nummeasured_valueupperlimitlowerlimitFollowing is what I need to automate-Thanks
ENTHU

Discussions |
Mar 4, 2021 5:06 AM

3425 views | 4 replies

Previous
Next

Latest Discussions

weekly report with SQLquery tables

I have 3 SQLQuery tables generated. Few questions:To generate a weekly report, what’s the best way to store them, so next week once I have updated data, I can replace the data source once, and then the 3 query tables run automatically? Is it like journal, project, or dashboard?How to combine the scripts of the 3 query tables in order to run them all at once with updated data? I saw in each table t...
joann

Discussions |
Mar 4, 2021 1:27 PM

2575 views | 2 replies
How to automate variability chart plotting?

I have a table with following information.I have this data for ~40 different tests and upper and lower limit are different for each of the test.How can I automate the variability chart plotting?part_numtest_nummeasured_valueupperlimitlowerlimitFollowing is what I need to automate-Thanks
ENTHU

Discussions |
Mar 4, 2021 5:06 AM

3425 views | 4 replies
Error bars for non-normal data

Hello JMP community, I wanted to hear what statisticians believe is the best way to depict error bars for skewed data?I have a non-normal distribution of measurements (mg of drug taken per a day across ~50 people across 3 days) and I have 3 groups of people. I'd like to make a line graph (not box plot) but I'm not sure what to put as the error bars. The main data points would be the median (not me...
thats_stats

Discussions |
Mar 2, 2021 12:23 PM

2563 views | 2 replies
Why are total effects sometimes more than 1 in variable importance?

Hello, I'm analyzing a DoE and had a look on the variable importance graphs. Surprisingly, the sum of the total effects of my parameters are greater than 1 sometimes (see picture below). I did not find anything in the documentation for this. Can someone explain, why the sum of the total effects can be greater than 1? Best, Christian
christianguhr

Discussions |
Mar 2, 2021 12:04 PM

1619 views | 1 replies
Combining Several JMP Reports (Graphs) via script?

Hello, I have 25 different graphs I've created via the Bivariate feature, and saved as independent .JRP files. I was wondering if there was a fast way to combine all of these reports into one file through scripting? Such as a dashboard for example, or another format (.PDF, .JRN, .JRP). I have tried to manually combine them into a dashboard, however JMP runs extremely slowly when I have more than ...
DanAlexander

Discussions |
Mar 2, 2021 11:55 AM

2339 views | 3 replies

Previous
Next

Latest Discussions

What does it mean when the solution path for Elastic Net is not single-valued?

Dear JMP Community, (W10, 64-bit, JMP Pro 15.2.1) I am running a model to assess the active predictors. I am doing this by using the Autovalidation add-in to generate a Null Factor for my data. I then use the GenReg platform to find estimates for each possible X-factor and then Bootstrap those estimates to get a better assessment of the contributions to the response. I came across a very stran...
SDF1

Discussions |
Feb 15, 2021 12:35 PM

1486 views | 0 replies
Return number from specified row of calculation column in either a text edit box or number edit box in an add in

Hello, I'm attempting to build an application in application builder. I have two modules currently. The first module is a series of number edit boxes and lists that allow the user to input values and make selections.After pushing a button, the inputs and/or list selections update table variables in a data table that subsequently updates column equations. The data table opens in the background so ...
tys5384

Discussions |
Feb 15, 2021 7:33 AM

1328 views | 0 replies
generalized regression

How do I get a whole model significance test when conducting a generalized regression using the negative binomial distribution? I can get the individual effect significance tests, but I do not see where I can get the whole model significance.
Mrubra

Discussions |
Feb 3, 2021 2:31 PM

1126 views | 0 replies
Tablebox <

Using JMP 12.x, I noticed that: tablebox() <<sort by column does sort the column fine, but it does not seem to preserve any existing cell coloring post row sort. Is there any way to force it to preserve the existing cell colors post row sorting?
thanks, DJ
djhanson

Discussions |
Jan 14, 2021 9:17 AM

1437 views | 0 replies
Comparing observed/predicted from different models. (Mean Absolute Deviation (MAD) or Mean Absolute Error (MAE))?

I'm using the neural platform to calculate a model that makes predictions from some observed data and want to compare the performance of that model to other models (not from JMP). To compare the different models, I want to compare the observed data and the predictions from the different models.The R2 is not a good measure because it checks for any linear relationship between the observed and predi...
matthias_bruchh

Discussions |
Jan 8, 2021 2:32 AM

4024 views | 0 replies