JMP User Community

Latest Discussions

How do I get Comma separated user input to subset rows with specific value?

Hi, I have a data table that contains information in the below format. I'd like to create a button on jmp that when clicked should prompt to enter a list of comma separated values from the user (possibly in a text box?) to subset just the rows with that value in a specific column.
For example in the text box if the user chooses BB,EE, then in the attached table (sample_table.jmp) only those rows wi...
psundar6

Discussions |
Mar 5, 2021 5:14 PM

2126 views | 2 replies
Help needed with the eGFR MDRD Formula

Hi all, I need help creating the following formula: eGFR = 175 x (SCr)-1.154 x (age)-0.203 x 0.742 [if female] x 1.212 [if Black] thanksOS
sanchezpeinado

Discussions |
Mar 5, 2021 9:28 AM

2493 views | 3 replies
Scripting the Width of Column Switcher in Graph Builder

I am scripting several visuals with column switchers and am finding that they default to a larger size than I would expect. I took the example JSL from another similar post Scripting-column-switcher-using-variable but tried to get change the column switcher width. I added a local data filter as I know that one can manipulate the sizes of those objects with "Display()". You may notice that I ad...
danielrbiber

Discussions |
Mar 5, 2021 9:15 AM

2048 views | 3 replies
Gleiche Excelgrafik in JMP erzeugen mit Graph Builder

Hallo zusammen,ich möchte gerne eine Grafik wie ich sie in Excel erstellt habe in JMP ebenfalls erstellen. Dabei habe ich drei Parameter, die ich in zwei Produktionsschritten messe und dann gegeneinander auftrage. Dabei erhalte ich dann in Excel untenstehende Grafik.In JMP habe ich die Parameter wie folgt benannt Parameter_1_Stufe_1; Parameter_2_Stufe_1; Parameter_3_Stufe_1 und Parameter_1_Stufe_2...
jan_kreuzmann

Discussions |
Mar 5, 2021 4:30 AM

1933 views | 3 replies
Using loop variable as column input

Hello, I am wondering if it possible to use my for loop variable, i, as an input for a new column, depending on the value of another column. Here is what I am thinking, but cannot get to work. dt << New Column("Site", Numeric, Formula( For(i = 1, i <= 8, i++, If(Contains(:Column1, i), i); ) ));
wyatt_dunn

Discussions |
Mar 5, 2021 1:10 AM

1462 views | 2 replies

Previous
Next

Latest Discussions

Using loop variable as column input

Hello, I am wondering if it possible to use my for loop variable, i, as an input for a new column, depending on the value of another column. Here is what I am thinking, but cannot get to work. dt << New Column("Site", Numeric, Formula( For(i = 1, i <= 8, i++, If(Contains(:Column1, i), i); ) ));
wyatt_dunn

Discussions |
Mar 5, 2021 1:10 AM

1462 views | 2 replies
How to color code by sample type in a PCA?

I am novice at JMP, and I am making my first PCA that I would like to color code by sample type (treatment) ... but I cannot figure out how. Any advice?My study compares a variety (15+) of carbon composition metrics of the leaves, litter, and soil of two different plant species in rivers versus creeks -- overall that is 12 sample types, or treatments.Any help would be greatly appreciated!I have JM...
harvestnoon

Discussions |
Mar 4, 2021 10:14 PM

3258 views | 1 replies
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

3430 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

2564 views | 2 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