JMP User Community

Latest Discussions

count(distinct val)

Hello All,Any function in Jmp similar to count distinct in sql?Examples:How can I obtain the values of count distinct subjectsid in a new column in these tables with functions?ThanksTABLA 1 subjectid count distinct subjectida 5b 5c 5a ...
unbbmas

Discussions |
Jul 31, 2024 4:20 AM

22781 views | 9 replies
How to script "save difference summary" of "compare data tables"

Hi,

I have a script that calls the compare data tables platform using:DTOriginal << Compare Data Tables(Compare with( DT2new ),Hide columns with no differences( 0 ),Hide rows with no differences( 0 ));After I can manually use the top left red triangle to "save difference summary", however this isn't recorded in the log or workflow builder. Can it be scripted and if so, how?
david707

Discussions |
Jul 31, 2024 2:39 AM

377 views | 1 replies
Change Date format

There is an error as I cannot run this, can anyone help?// Function to reformat dates to dd/mm/yyyy
colName = Column Dialog( "Select Date Column" );
reformatDateColumn = Function({dt, colName},
dt = Current DataTable();If( Column( dt, colName ) == Empty(),
Throw( "The selected column does not exist in the current data table." );
);// Function to identify and reformat the date
formatDate = Function({date...
DecileIbex201

Discussions |
Jul 30, 2024 9:51 PM

580 views | 2 replies
Select all the points shown in graph builder?

I have this data in graph builder and I was wondering if there was a way with JSL to select all the points that are showing in the current GB arrangement? This would save me from having to hold down control and select all the point in each panel by panel. On some GB arrangements this can be a lot of panels to work through!
shampton82

Discussions |
Jul 30, 2024 3:01 PM

430 views | 1 replies
How to create multiple line graph with categorial x axis

Hi,Jmp newbie here so pretty basic question: how do I plot a series of line plots with categorical x axis? right now the graph builder is duplicating every category on the x axis? Thanks!
stat3

Discussions |
Jul 30, 2024 2:54 PM

910 views | 4 replies

Previous
Next

Latest Discussions

How to script "save difference summary" of "compare data tables"

Hi,

I have a script that calls the compare data tables platform using:DTOriginal << Compare Data Tables(Compare with( DT2new ),Hide columns with no differences( 0 ),Hide rows with no differences( 0 ));After I can manually use the top left red triangle to "save difference summary", however this isn't recorded in the log or workflow builder. Can it be scripted and if so, how?
david707

Discussions |
Jul 31, 2024 2:39 AM

377 views | 1 replies
Change Date format

There is an error as I cannot run this, can anyone help?// Function to reformat dates to dd/mm/yyyy
colName = Column Dialog( "Select Date Column" );
reformatDateColumn = Function({dt, colName},
dt = Current DataTable();If( Column( dt, colName ) == Empty(),
Throw( "The selected column does not exist in the current data table." );
);// Function to identify and reformat the date
formatDate = Function({date...
DecileIbex201

Discussions |
Jul 30, 2024 9:51 PM

580 views | 2 replies
Select all the points shown in graph builder?

I have this data in graph builder and I was wondering if there was a way with JSL to select all the points that are showing in the current GB arrangement? This would save me from having to hold down control and select all the point in each panel by panel. On some GB arrangements this can be a lot of panels to work through!
shampton82

Discussions |
Jul 30, 2024 3:01 PM

430 views | 1 replies
How do to determine optimal biomarker cutoff in a multivariable logistic regression model

Dear Colleague My lab has discovered a biomarker that predicts bad outcomes for pregnant moms. I am trying to figure out how to determine an optimal cutoff in the multivariable model, i.e., one that includes all the clinical characteristics and the biomarker that predicts the binary outcomes, i.e., bad outcomes for pregnant moms. I use the decision threshold tool to change the sensitivity and spe...
jambo

Discussions |
Jul 30, 2024 9:31 AM

598 views | 1 replies
Make JSL script more efficient for sampling a 'sliding window'

Hello, I'm trying to create a script that will sample a data table with a 'sliding window' (sampling a set number of rows of a set 'width', then moving up a row to sample the next set, resulting in a data set of rows 1-10, 2-11, 3-12 and so forth) sampling of my data table, creating a new data set that I can use for pattern analysis. My script is operational, but doesn't work well for larger dat...
33909

Discussions |
Jul 30, 2024 4:34 AM

419 views | 2 replies

Previous
Next

Latest Discussions

How do I add Mean and other values to BoxPlot in JMP Pro 17

I have created a Boxplot graph and I need to show the Mean and other relevant stats/values and text inside or close to the Box and not on the top as part of the Summary Stats. I also need to be able to manipulate the figures like make it bigger, bold, etc...full customization like the attached Boxplot picture. Any suggestions? Thank you, Helal
Helal

Discussions |
Jul 22, 2024 11:57 AM

545 views | 0 replies
JMP Methode zur Reliabilitätsanalyse einer Scorecard

Hallo zusammen, ich bin unsicher bezüglich der Methode zur Reliabilitätsanalyse einer Scorecard.Ich möchte eine Scorecard bzgl. Ihrer Reliabilität analysieren. 5 verschiedene Anfragen werden dabei über eine Scorecard von jeweils 4 verschiedenen Personen bewertet. Jede der 5 Anfragen erhält dadurch einen Gesamtscore. Ich möchte gerne untersuchen, wie "gut" unsere Scorecard zur Bewertung unserer Anf...
ConstructFish94

Discussions |
Jul 22, 2024 6:38 AM

452 views | 0 replies
Feedback : 404 page for adobe svg plugin

Setup : JMP 17.0.0 on Win11.I create boxplots and export to HTML (default graphics format = SVG).
On line 16 of the html file, there is an autogenerated link to adobe :pluginspage="http://www.adobe.com/svg/viewer/install/"This webpage doesn't exist and I think the Adobe SVG Viewer is not available anymore, so the above link should be removed.https://web.archive.org/web/20121221000422/http://www.ado...
kkchen

Discussions |
Jul 7, 2024 10:33 PM

451 views | 0 replies
How do I get the partial eta squared for a model with random effects?

Hello, I am conducting a two-way ANOVA with a random effect and need to report the partial eta squared. Does anyone know how to do this or calculate it from values displayed in the output? I tried the add-on but it does not support models with random effects. For the model I have a dependent variable and my model effects looks like:variable1variable2variable1*variable2variable3 & random all variab...
ELM890

Discussions |
Jul 2, 2024 9:53 AM

520 views | 0 replies
Hyperparameters and neural network architecture

Hello,I'm trying to reproduce the results obtained on JMP with the "Neural" model by adding nested cross-validation, which is not possible on the software. However, the architecture is very unclear and I can't understand the calculations performed by the model. I don't have access to certain information such as batch size, optimizer used, loss, learning rate (except the one for the boosting), and ...
Grizzly

Discussions |
Jul 2, 2024 5:42 AM

417 views | 0 replies