JMP User Community

Latest Discussions

How to apply "Max Selected" to a check box list

Hi, Is it possible to apply the "Max Selected" filter to limit the number of Check Boxes that a User can select?I will appreciate your suggestions.Names Default To Here( 1 ); New Window( "Example", cb = Check Box( {"One", "Two", "Three"}, Max Selected(2), Print( "Selected: " || Concat Items( cb << Get Selected(), ", " ) ) ) );
ALopez

Discussions |
Jan 19, 2021 11:16 AM

2005 views | 3 replies
Substitute characters in strings with new lines and tabs

I am writing a OLEDB query that needs the SQL command to be in a string without containing end of lines or tabs, only spaces. The following works, but I cannot find how to do this without having to create the 'empty' strings. User may modify the SQL query, using JMP installed in Windows machines. SQL_query = "SELECT a, b, c FROM mytable WHERE a = 'alice' AND b BETWEEN '86' AND '91'"; // Clean...
FN

Discussions |
Jan 19, 2021 11:13 AM

1977 views | 3 replies
Scripting Guage R&R with tolerance Intervals

Hi, I am a new user to JMP and JSL scripting. I am trying to script a guage R&R and would like to include the tolerance interval in the script. I already have a column (Named "Tolerance Interval") with tolerance intervals for each of my parameters. (Note that I am splitting the analysis by Parameter and each Parameter has a different tolerance interval). The script I have tried is below. It w...
RSDK_JMP

Discussions |
Jan 19, 2021 7:15 AM

2151 views | 3 replies
Transfer data from/ Excel/VBA to JMP and get data back to VBA

Hi, I'd like to describe what I need in order to have some kind of automation I'm planning.I have a report I've already generated using Excel/VBA and I'm missing a distribution graph from JMP which is currently being made manuallyAnd added to the report.I'd like to know how can I send the data from Excel to JMP, generate the distribution graph and save it back to my excel sheet. To be specific, le...
Lirsch

Discussions |
Jan 19, 2021 3:05 AM

1763 views | 1 replies
How to graph a column chart with error bars calculated in JMP

Hello all, I am a new to JMP and am trying to understand or figure out how to plot a column chart and include error bars calculated in JMP. To illustrate my question I have attached a screenshot of the column chart and error bars I would like to generate. The dataset has 4 replicates denoted R1-R4. I would like to calculate the mean of R1&2 and separately calculate the mean of R3&R4. The resulti...
censoredcactus

Discussions |
Jan 18, 2021 11:28 PM

4829 views | 3 replies

Previous
Next

Latest Discussions

Scripting Guage R&R with tolerance Intervals

Hi, I am a new user to JMP and JSL scripting. I am trying to script a guage R&R and would like to include the tolerance interval in the script. I already have a column (Named "Tolerance Interval") with tolerance intervals for each of my parameters. (Note that I am splitting the analysis by Parameter and each Parameter has a different tolerance interval). The script I have tried is below. It w...
RSDK_JMP

Discussions |
Jan 19, 2021 7:15 AM

2151 views | 3 replies
Transfer data from/ Excel/VBA to JMP and get data back to VBA

Hi, I'd like to describe what I need in order to have some kind of automation I'm planning.I have a report I've already generated using Excel/VBA and I'm missing a distribution graph from JMP which is currently being made manuallyAnd added to the report.I'd like to know how can I send the data from Excel to JMP, generate the distribution graph and save it back to my excel sheet. To be specific, le...
Lirsch

Discussions |
Jan 19, 2021 3:05 AM

1763 views | 1 replies
Add values to x# of lag rows

I want to fill the previous 48 rows with the value of row i. I've got a dataset that is a continuous timeseries with a row for every 5 min increment of time. I have an identification column for select periods (e.g. ID#1, 2, 3, ... 1000). Not every row gets an identifier, just select periods of time. Now say row 1200 is the first value of ID # 250. I want the previous 48 rows (so rows 1152-1199), c...
RVhydrA

Discussions |
Jan 18, 2021 7:03 PM

1244 views | 1 replies
Interpretation of a Factorial Design with binary outcome

Hello!

I am struggling with interpretation of factorial design with 4 elements. Before I tried experiments with 2 elements, and results were straightforward.Here in the attachment you can see my jmp dataset file with the experiment. As a result of removing non-significant elements I came to a conclusion that only C and В are significant with negative effect.
Is my conclusion correct?
Rsquare value is...
gustavjung

Discussions |
Jan 18, 2021 9:40 AM

7283 views | 8 replies
How to create a range control chart based on the median range and not the average range

Is there any easy way to use JMP 13 to create a range chart based on the MEDIAN range and not the average range? (Hence the upper range limit would also be based on the median range as well.)If not I assume one option is to use the run chart and adapt it through scripts. I'd put the range values for all the subgroups into a list, find the median of this list, and then take it from there (i.e. addi...
scottahindle

Discussions |
Jan 18, 2021 8:41 AM

10205 views | 10 replies

Previous
Next

Latest Discussions

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

1515 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

4256 views | 0 replies
Graph Builder - Remove Combine Scales?

In graph builder I am interested in plotting a simple Y vs X for multiple X variables. By default graph builder combines all the different X variables on the same X axis and scale. Is there a simple way to change the X axis to have separate scales on the X axis for each variable? Default graph builder (script1, graph1)Plot 1 variable on Y axis vs 8 variables on X axisAll 8 variables on same x-axis...
ehorne

Discussions |
Oct 29, 2020 9:11 AM

1908 views | 0 replies
SharePoint Online

My company recently began the migration from SharePoint 2010 to SharePoint Online. I have found that my JSL scripts are now no longer able to open or save files to the new SPO site. Anyone have the correct updated syntax for this. Example 1 (SP 2010): This worked. TablePath4 = "\\sharepoint.amr.ith.company.com@ssl\sites\rpt\documents\JMP_tables\"; //set variable TablePath path location Tabl...
Outdoorsman1963

Discussions |
Oct 23, 2020 4:06 PM

1596 views | 0 replies
How to run a Post hoc for Chi Square results in JMP?

I was wondering if someone can help me. I want to run a post hoc analysis for the chi square results in JMP. Thanks
vmendez17

Discussions |
Oct 22, 2020 7:33 PM

1017 views | 0 replies