JMP User Community

Latest Discussions

Can you create a Stacked Data Table with only the selected rows

I have tried it a couple of different ways but none of them seem to work. I am trying to find a way using JSL to create a stacked data table but only with the rows I have selected. I am using the JSL inside of a Workflow.Data Table( "My Table" ) << Clear Select << Select Where( :Name("5 Million") == "Over 5 Million" ) << Stack( columns( :"Baseline Percent Change"n, :"District Percent Change"...
ACraig

Discussions |
Aug 14, 2024 12:18 PM

744 views | 1 replies
Reducing a model to only one-two terms

Hello all, I'm currently analyzing a 4 factor half-factorial design. My pareto chart is indicating that only one-two main effects for given responses are significant. Would it be acceptable to remove the remaining insignificant main effect and interaction terms from the model? I've trialed this, by reducing the model as described above. The R2 and Adjusted R2 are close (0.68 vs 0.63), so not fanta...
DoEDorkily123

Discussions |
Aug 14, 2024 10:10 AM

620 views | 1 replies
PNG Export Issues for Dashboard in JMP 16

Hi everyone, I have a question about saving a dashboard as a PNG in JMP 16. I found an example in an old question, but it doesn't work for me.I received this response: Unresolved name: dash at line 13 while accessing or evaluating "dash", dash/*###*/
at line 440 in D:\Project JMP\Scripts\PourcentageDeNokParJour.jsl. results_table = Open( "D:/Project JMP/Tables Resultats NOK percentages/Results.jm...
Yass

Discussions |
Aug 14, 2024 6:37 AM

1866 views | 6 replies
Calculate Column Difference for other column levels where lag varies

I have a column :EVENT (character-nominal) with various values. Also another column :datetime (numeric-continuous). I have :datetime column sorted ascending. I am interested in having another column calculate for whenever there is a "CONNECT" event, what is the time difference between it and the last "DISCONNECT" event. The issue is that the lag can vary between a CONNECT and previous DISCONNE...
ashwint27

Discussions |
Aug 13, 2024 2:37 PM

1605 views | 5 replies
How to save the benchmarks window to the data table ?

Hi ! Thanks to this script I generate à window of BenchMarks on jmp and I would like to save it to the data table ( like if I was doing "save script to data table") The problem is that the end of my script doesn't work !! // Ouvrir la table de données dt = Open(fichier1); // Initialiser une liste pour stocker les noms des colonnes avec la note "INGOT CHARACTERISTICS" cols_with_note = {}; //...
PercentileBat71

Discussions |
Aug 13, 2024 12:45 PM

4652 views | 18 replies

Previous
Next

Latest Discussions

Reducing a model to only one-two terms

Hello all, I'm currently analyzing a 4 factor half-factorial design. My pareto chart is indicating that only one-two main effects for given responses are significant. Would it be acceptable to remove the remaining insignificant main effect and interaction terms from the model? I've trialed this, by reducing the model as described above. The R2 and Adjusted R2 are close (0.68 vs 0.63), so not fanta...
DoEDorkily123

Discussions |
Aug 14, 2024 10:10 AM

620 views | 1 replies
How to save the benchmarks window to the data table ?

Hi ! Thanks to this script I generate à window of BenchMarks on jmp and I would like to save it to the data table ( like if I was doing "save script to data table") The problem is that the end of my script doesn't work !! // Ouvrir la table de données dt = Open(fichier1); // Initialiser une liste pour stocker les noms des colonnes avec la note "INGOT CHARACTERISTICS" cols_with_note = {}; //...
PercentileBat71

Discussions |
Aug 13, 2024 12:45 PM

4652 views | 18 replies
How to save to data Table but with script

Hello, I would like to save the following script which generates several BenchMarks in a FitGroup via a loop as if I were doing a "save to data table" but dynamically (compared to the loop) how to do it? // Ouvrir la table de données dt = Open( fichier1 ); // Initialiser une liste pour stocker les noms des colonnes avec la note "INGOT CHARACTERISTICS" cols_with_note = {}; // Parcourir chaque c...
PercentileBat71

Discussions |
Aug 13, 2024 9:02 AM

1075 views | 3 replies
Some Insights on Dynamic Column Formulas

Being a JSL beginner, I find I often struggle with script interpretation. If I find a script in a discussion that seems to address my problem and try to customize it, I often break it and have a hard time understanding how to fix it. During my JSL scripting journey I have heavily relied on this forum for assistance -- both searching the extensive archives for past answers and asking for help if th...
scott1588

Discussions |
Aug 12, 2024 12:45 PM

1093 views | 3 replies
How do I count number of non-blank rows across specific rows?

I have the table displayed here and would like to make a new column that contains "N" which is the number of columns that have numbers but only for the columns labelled "DecodeCount_BW**". For example for the first row, it should return "5", for the second row it should return "2", etcIn Excel I do this with "counta", but trying to learn JMP for improved statistical analysis, but I've getting stuc...
ConfusedUser123

Discussions |
Aug 12, 2024 10:38 AM

1348 views | 2 replies

Previous
Next

Latest Discussions

Characters as Markers: How to get rid of the shadows?

I like the ability to add outlines to data points. This is very useful for separating partially overlapping data points.Unfortunately, when characters are used as markers, the outline mode looks very unprofessional - kind of like shadows, but without blur.Besides turning off the outline mode - is there a way to get rid of the "shadows"? (view in My Videos) Names Default to Here(1); dt = Open( "$S...
hogi

Discussions |
Aug 9, 2024 3:04 AM

524 views | 0 replies
I would like to find another political scientist or other social scientist who has worked with mapping congressional districts and counties

There are great bodies of data presented by counties (disease incidence, education, income). There are other bodies of data presented by congressional districts (incumbents, vote percentages, etc.) I want to find someone who has mapped the counties and the congressional districts into the same space. I know this can be done with ESRI products, but I wanted to avoid jumping off the JMP platform....
LNitz

Discussions |
Aug 8, 2024 8:15 PM

598 views | 0 replies
App Interface saved in a journal

Hi There
Some time ago, I created a nice interface using Application Builder and I saved it as a journal. Now I need to make a few modifications to the interface, rearrange buttons, add boxes, and so on. I am unable to import the journal into the app and have the interface appear in the Module tab. It is a very busy interface ...Is there a way to have it?
Thanks
Mioffe

Discussions |
Aug 7, 2024 5:01 PM

516 views | 0 replies
Multivariate Rho Boostrap option not in Mac Jmp 17.

I am not getting the bootstrap option after running multivariate Spearson's Rho. How to proceed further? I want a forest plot with correlation and CI. <Jmp17>
NoSQLBird361

Discussions |
Aug 2, 2024 11:00 AM

521 views | 0 replies
Overlying map files and merging content

I have two map files--one of economic and health conditions by US county. The other of congressional districts. I wish to overlay the county map on the congressional district map and attrribute the county measures to the ( larger opr smaller) congressional districts. For example, what is the average rate of coronary heart disease in districts represented by women versus those represented by m...
LNitz

Discussions |
Aug 1, 2024 2:04 AM

514 views | 0 replies