JMP User Community

Latest Discussions

How to customized graph builder customized label display

Hi, By default when i show the label on graph builder, it show all data that used on X-axis, Y-axis and row. Can i customized the label only show what i want. I don't want to many unnecessary information on the info box. Please advise. Thanks eg. I only want yield and another item (wafer) that i choose.
OneNorthJMP

Discussions |
Feb 7, 2021 7:27 AM

2376 views | 2 replies
Need help converting a date format from character to numeric in JMP 15

Hi, My Excel sheet has the date format as: Wednesday, November 18, 2020, 12:45:00 PM. Upon importing into JMP 15, it is read as a character. Can you please share a method to convert the date from its character format to a numeric-continuous format (e.g., yyyy-mm-dd hh:mm)? I have attached a JMP file for your reference.Is there is a way to apply the correct (numeric) date format during import?Thank...
sumit_dutta

Discussions |
Feb 6, 2021 8:18 AM

2343 views | 2 replies
Alternative to "Select duplicate rows"

Hey guys,
I'm looking for an alternative to the "Select duplicate rows" function that does not exist in JMP12.
My aim is to delete duplicate rows by column value, with an exception of specific valueFor example, if I have this my data table, I want to leave the first substances of column "Color", With an exception that if the "Color" column value is Yellow, leave all these rows and don't delete them...
Stas

Discussions |
Feb 6, 2021 5:09 AM

1983 views | 3 replies
Mise en tableau des données

Bonjour,lorsque on fait une mise en tableau des données, peut-on mettre intitule d'une colonne sur deux ligne lorsqu'il est trop long.Si oui commentMerci
GPL12

Discussions |
Feb 5, 2021 10:19 PM

1314 views | 2 replies
JMP Query Builder -- how to apply "HAVING" feature?

Hello all, I have several SQL queries with "HAVING" features. I would like to see whether it can be set in JMP Query Builder. I searched over this community, but I did not see discussions on it (maybe I missed?). I understand there is one custom SQL feature that can be used to achieve this function. But the issue is in that way all nice JMP Query Builder interactive features won't be seen any more...
TG

Discussions |
Feb 5, 2021 3:16 PM

2686 views | 4 replies

Previous
Next

Latest Discussions

How to customized graph builder customized label display

Hi, By default when i show the label on graph builder, it show all data that used on X-axis, Y-axis and row. Can i customized the label only show what i want. I don't want to many unnecessary information on the info box. Please advise. Thanks eg. I only want yield and another item (wafer) that i choose.
OneNorthJMP

Discussions |
Feb 7, 2021 7:27 AM

2376 views | 2 replies
Need help converting a date format from character to numeric in JMP 15

Hi, My Excel sheet has the date format as: Wednesday, November 18, 2020, 12:45:00 PM. Upon importing into JMP 15, it is read as a character. Can you please share a method to convert the date from its character format to a numeric-continuous format (e.g., yyyy-mm-dd hh:mm)? I have attached a JMP file for your reference.Is there is a way to apply the correct (numeric) date format during import?Thank...
sumit_dutta

Discussions |
Feb 6, 2021 8:18 AM

2343 views | 2 replies
Alternative to "Select duplicate rows"

Hey guys,
I'm looking for an alternative to the "Select duplicate rows" function that does not exist in JMP12.
My aim is to delete duplicate rows by column value, with an exception of specific valueFor example, if I have this my data table, I want to leave the first substances of column "Color", With an exception that if the "Color" column value is Yellow, leave all these rows and don't delete them...
Stas

Discussions |
Feb 6, 2021 5:09 AM

1983 views | 3 replies
Mise en tableau des données

Bonjour,lorsque on fait une mise en tableau des données, peut-on mettre intitule d'une colonne sur deux ligne lorsqu'il est trop long.Si oui commentMerci
GPL12

Discussions |
Feb 5, 2021 10:19 PM

1314 views | 2 replies
If select where does not find value then do x else continue with rest of script

Hello and Happy Friday, I am trying to find a way around this one. I have a part in my script where it uses the following below. The issue I have is when it does not find the value ABC in Column1. Basically, I want it to where it runs the code below but if it does not find ABC, then I want it to save a blank table (csv) and stop running the rest of the code. If it does find ABC , then I want it ...
Josee

Discussions |
Feb 5, 2021 12:39 PM

1027 views | 1 replies

Previous
Next

Latest Discussions

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

1122 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

1433 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

4020 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

1770 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