JMP User Community

Latest Discussions

Graph Builder: removing empty sub-graphs using JSL

Hi, I'm using JSL to produce graph builder plots. These plots are plotted against one or multiple variables. The problem is that sometimes, graph builder produces empty plot with no value. Is there are a method to remove those empty sub-graphs? For a better understanding of the problem, I have attached an example. In the example, ALICE, DAVID, ..etc. have empty plots. Those are the one I'm trying ...
RA899

Discussions |
Mar 19, 2024 10:31 AM

5013 views | 9 replies
Import of 3 sheets from the same Excel file

Hello all,I would like to import 3 sheets from the same Excel file in JMP.My Excel fil is encrypted with a password.If I import the 3 sheets (AAA, BBB, and CCC) with the following code (written 3 times), I need to write 3 times the password:Open( "/P:/XXX/TEMPLATE.xlsx", Worksheets( "AAA" ), Use for all sheets( 1 ), Concatenate Worksheets( 0 ), Create Concatenation Co...
Sebastienlg

Discussions |
Mar 19, 2024 2:47 AM

1577 views | 2 replies
How to script date of the current month for data compilation

Hi all, I have the following code which does not work :// Current date aujourd'hui = Text(Today(),"00000000"); // Obtain the month number format "MM" numero_mois = Text(Month(aujourd'hui), "00"); // Obtain the year number - 1 format YYYY numero_annee = Text(Year(aujourd'hui) - 1, "0000"); // Concatenate the result date_debut_mois_actuel_Y = ("01" || numero_mois || numero_annee); // Show the re...
Arkawa

Discussions |
Mar 19, 2024 2:18 AM

6694 views | 10 replies
Hide x-axis and y-axis number label

Hello JMP community, I am preparing my talk on the upcoming discovery summit. Because of confidentiality reasons I cannot show the y and x-axis labels. See pic, where I removed the axis box via the properties visibility option. Normalizing all the data to range 0 to 1 changes all the analyses I did with scripts. So as I see it, I need to keep the original (confidential) numbers but need...
Benjamin_Fuerst

Discussions |
Mar 19, 2024 12:22 AM

6291 views | 9 replies
import of a Excel file with column name containing formulas

Hello all, I would like to import an Excel file in JMP. However, the column name are formulas that allow to import names from another Excel sheet and it doesn't work. Here are the names of the imported column:Do you know if the is a way to import a such Excel file? Thank you in advance,Sébastien
Sebastienlg

Discussions |
Mar 18, 2024 8:24 AM

3141 views | 6 replies

Previous
Next

Latest Discussions

import of a Excel file with column name containing formulas

Hello all, I would like to import an Excel file in JMP. However, the column name are formulas that allow to import names from another Excel sheet and it doesn't work. Here are the names of the imported column:Do you know if the is a way to import a such Excel file? Thank you in advance,Sébastien
Sebastienlg

Discussions |
Mar 18, 2024 8:24 AM

3141 views | 6 replies
Note Column Property & Hover Pop-up: how to manipulate?

So, apparently if the Column Property Notes is set, it enables a hover pop-up (when you hover over the column name) displaying the contents of the Notes field. To see this in action: Sample Data>Polyethylene Process.jmp. In this case, the column names are very short and not descriptive. By hovering over the column name, the descriptive Note pops-up. This is a great feature!!! So, my issue is the f...
markschahl

Discussions |
Mar 18, 2024 1:36 AM

1715 views | 2 replies
How can I fix the seeds of the clusters in the normal mixtures clustering method so that it gives a fixed result every time it is run?

Hi there,
I want to use normal mixtures method to cluster my data, but it gives a different result every time it is run. Does anyone know how I can fix the seeds of the clusters?
SepidehSj

Discussions |
Mar 14, 2024 12:55 AM

1135 views | 1 replies
Add-in doesn't work after installation

I can install the add-ins to my JMP 16 and JMP 17, it is also 'enabled'. However, when I click it, nothing happens (there supposed to be a pop-up window). Please help. Thank you!
SevenPP

Discussions |
Mar 13, 2024 1:51 PM

2940 views | 5 replies
Creating a report makes my fit groups non-interactive

Good morning/afternoon/evening everyone, Having this strange issue where when I report a fit group I made to a tabbed report it makes the plots non-interactive (red triangle not doing the usual stuff). Screen shot here shows what happens when I click on the red triangle.Here is where I make the tabbed report:////////////////////////Show graphs for each test////////////////// Tests = db_Tests:Te...
OhThatArabGuy

Discussions |
Mar 13, 2024 9:42 AM

1029 views | 1 replies

Previous
Next

Latest Discussions

DataTable Prompt in application builder on module load

Hello guys, I have applciation builder with multiple modules. one of the module only contains column list which requires selection of datatable. How to make jmp prompt to select datatable only when that module loads.By default it prompts when the application loads Kindly guide. Thanks in advance
ComplexNerd

Discussions |
Mar 7, 2024 3:54 AM

662 views | 0 replies
JMP Project Global Data Filter and Column Switcher

Hello Guys, I just started exploring jmp project. I am wondering if there is any option to add Global Data Filter and a global column switcher to a jmp project.Currely i have created a jmp project with various reports from a datatable (similar to dashboard) but i want to know if there is a option to add a global data filter and also a global column switcher to this screen. My idea : To create a sc...
ComplexNerd

Discussions |
Mar 7, 2024 12:10 AM

621 views | 0 replies
"If" returns error response

I have a script to draw charts and use "if" for the reference line."Sometimes" the reference line is not correct. For example, when Rel_Test=H3TRB, the reference line should be 10, but it shows 5.How could I fix it? d6_graph=dt2 << Graph Builder( Size( 400, 300 ), Show Control Panel( 0 ), Variables( X( :Lot), Y( :dIGSS, Position( 1 ) ), Color( :Lot ), By(:Rel_Test) ), Elements( Box Pl...
LT

Discussions |
Mar 4, 2024 8:08 PM

941 views | 0 replies
Neural networks that learn and predict in real time (incremental learning)

Hello community!!A query:- How JMP is configured to generate neural networks that learn from their inputs in real time (incremental learning) in such a way that it continually updates its weights according to new inputs and generates updated real-time predictions.Greetings,Marco
Marco2024

Discussions |
Mar 4, 2024 9:37 AM

850 views | 0 replies
group file name and set lable by JSL looping, work fine but slowly

I have a JLS works fine, but slowly, is there any method to improve it? 1. import multiple files2. base on file name rule group into a, b, c, d, e 3. base on file name rule to decide file count and set into rows for each groupNames Default To Here(1); dir = Pick Directory( "Select a directory" ); Multiple File Import( <<Set Folder( dir ), <<Set Show Hidden( 0 ), <<Set Subfolders( 0 ), <<Se...
BayesRabbit7133

Discussions |
Feb 22, 2024 12:24 AM

860 views | 0 replies