JMP User Community

Latest Discussions

Order Bar Chart by Y-Axis Values?

I am new to JMP (using the trial of JMP 9) and completely stumpped on something that should be fairly simple. I hugely appreciate any guidance!I am making a bar chart that displays data from 2 separate years for each categorical value. I sorted the numerical data in one of the columns in ascending order, but the bar chart is displaying the categories in alphabetical order instead of the order th...
vhemingway

Discussions |
Jan 20, 2021 4:48 PM

15594 views | 5 replies
Extracting a number from a text field

I have a column containing text notes entered by technicians. They enter the system usage hours, which I need to extract into it's own column. Fortunately, the data is pretty consistent, and so I have been able to pull the info out using Regex Match(), but selecting the last value is tripping me up.Regex Match( :diagnosis, "(ys.+sage: ?)(\d{1,5})\n" );How do I extract the System Usage hours from t...
robressler

Discussions |
Jan 20, 2021 1:29 PM

1363 views | 2 replies
New Column Set Value Help

I know the following script is incorrect: a = {"a", "b", "b"}; b = [1, 2, 3]; c = [4, 5, 6]; New Table( "SQL Results", New Column( "a", character, set values( a ) ), New Column( "b", formula( If( :a == "a", set values( b ), set values( c ) ) ) ) ); How do I change it to make the output: a 1
b 5
b 6 so the first row checks if column 1 is "a", yes then use b[1]; se...
jy06115197

Discussions |
Jan 20, 2021 10:45 AM

1542 views | 2 replies
action when selected

Hey,I want to know if it is possible to call a function or an action when rows are selected in the data table.for example- when the user push a button it will lead to other actions to happen, I want it to happen when to user select a value in a Bivariate chart. Thank you for the help.
shiro

Discussions |
Jan 20, 2021 10:15 AM

8081 views | 6 replies
JSL Compare value in row to the next row.

Hello,I am trying to use "FOR" and "IF" to create a condition column. I have this table and I want the "Con" column to indicate if the age in the row after is lower then the current row. if yes "1" if not "0"NameAgeConDavid230Bari261James120Lora140 This is what I have: (doesn't work)dt<< New Column( "Con", Formula( For( i = 1,i <= N Row( dt ), i++, If(:Age[i] >= :Age[i+1] , "0", "1", )))); Your he...
ileshem

Discussions |
Jan 20, 2021 8:06 AM

3613 views | 3 replies

Previous
Next

Latest Discussions

Extracting a number from a text field

I have a column containing text notes entered by technicians. They enter the system usage hours, which I need to extract into it's own column. Fortunately, the data is pretty consistent, and so I have been able to pull the info out using Regex Match(), but selecting the last value is tripping me up.Regex Match( :diagnosis, "(ys.+sage: ?)(\d{1,5})\n" );How do I extract the System Usage hours from t...
robressler

Discussions |
Jan 20, 2021 1:29 PM

1363 views | 2 replies
saving script to data table issue

HI all, I have written a script (a few hundred lines) that 1) opens an existing data table, 2) does a whole bunch of calculations and then 3) spits out a new data table with results from these calculations. Because I am continually improving the script, I want to make sure that I know which exact version of the script was used to create the new output data table and so thought of saving the whole...
yvesprairie

Discussions |
Jan 19, 2021 7:11 PM

2779 views | 6 replies
Display a stopwatch counter (parallel with another JSL action)

Does anyone know how to display a time counter (say 1 sec intervals using a wait(1) ), but while another JSL action is taking place? So this stopwatch counter would display like 1, 2, 3,.... until that other action finished like pulling data from a database. This stopwatch counter would be running in parallel in this case and keep running while waiting on the data pull to complete. Is parallel ...
djhanson

Discussions |
Jan 19, 2021 6:02 PM

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

1932 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

1647 views | 1 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

1434 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

4022 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

1773 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

1507 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

959 views | 0 replies