JMP User Community

Latest Discussions

How Can I Delete Rows Given A Condition in JSL

Hello. I am a JSL rookie but have some scripting experience with VBA and Python. I have a table that has two columns 'purification_run' and 'parent_purification_runs'. I want to delete each row that has a 'purification_run' field that is contained in any of the 'parent_purification_runs' fields. I wrote the following JSL script to accomplish this, and it runs, but does not perform the intended del...
bio_guy

Discussions |
Jan 22, 2024 8:16 AM

858 views | 1 replies
Help with PCA analysis

Hello everyone,
I am trying to make a comparison between different populations of an animal according to a variety of morphological features. I have numerical data (such as length, weight, etc.) and binary data. Not every one of the details I have has all the data, meaning that each characteristic has a different number of details with information available. I am trying to do a PCA on the data in o...
yoram_frumkin

Discussions |
Jan 22, 2024 6:04 AM

1592 views | 1 replies
Build Error Bars with 3 standard deviations from the mean using 'Graph Builder'

How do I build a line graph with a 3 standard deviation from mean instead of 1 standard deviation?
PowerPlatypus37

Discussions |
Jan 22, 2024 5:15 AM

2215 views | 4 replies
help with model comparsion: DOE vs ANN boosted

Good morning guys! 1) I have a DOE and some boosted neural network models that I would like to compare their respective Rsquared (largest), RASE (smallest) and AAE (smallest) to select the best optimized models from my experiments. I saw that in the "Model Comparison" tool, through the predictive formulas saved in the experiment spreadsheet, I can make the selection according to the criteria above...
ivanpicchi

Discussions |
Jan 22, 2024 3:24 AM

3044 views | 5 replies
Liket scale with subscales

I have 3 Likert scales, and 2 have subscales. How do I first find the sum of each survey and then the individual subscales to make a new variable to test SLR for mediations..
SeasonalShark96

Discussions |
Jan 22, 2024 1:01 AM

1248 views | 2 replies

Previous
Next

Latest Discussions

How Can I Delete Rows Given A Condition in JSL

Hello. I am a JSL rookie but have some scripting experience with VBA and Python. I have a table that has two columns 'purification_run' and 'parent_purification_runs'. I want to delete each row that has a 'purification_run' field that is contained in any of the 'parent_purification_runs' fields. I wrote the following JSL script to accomplish this, and it runs, but does not perform the intended del...
bio_guy

Discussions |
Jan 22, 2024 8:16 AM

858 views | 1 replies
Help with PCA analysis

Hello everyone,
I am trying to make a comparison between different populations of an animal according to a variety of morphological features. I have numerical data (such as length, weight, etc.) and binary data. Not every one of the details I have has all the data, meaning that each characteristic has a different number of details with information available. I am trying to do a PCA on the data in o...
yoram_frumkin

Discussions |
Jan 22, 2024 6:04 AM

1592 views | 1 replies
Build Error Bars with 3 standard deviations from the mean using 'Graph Builder'

How do I build a line graph with a 3 standard deviation from mean instead of 1 standard deviation?
PowerPlatypus37

Discussions |
Jan 22, 2024 5:15 AM

2215 views | 4 replies
help with model comparsion: DOE vs ANN boosted

Good morning guys! 1) I have a DOE and some boosted neural network models that I would like to compare their respective Rsquared (largest), RASE (smallest) and AAE (smallest) to select the best optimized models from my experiments. I saw that in the "Model Comparison" tool, through the predictive formulas saved in the experiment spreadsheet, I can make the selection according to the criteria above...
ivanpicchi

Discussions |
Jan 22, 2024 3:24 AM

3044 views | 5 replies
Liket scale with subscales

I have 3 Likert scales, and 2 have subscales. How do I first find the sum of each survey and then the individual subscales to make a new variable to test SLR for mediations..
SeasonalShark96

Discussions |
Jan 22, 2024 1:01 AM

1248 views | 2 replies

Previous
Next

Latest Discussions

Custom Binning - how to edit the bins?

Wow, custom binning even works with dates, cool! There is even a possibility to edit the binning. But: quite uncomfortable to type in the dates in seconds and to correct the labels manually.What do I have to change in my workflow to be able to enter the "dates" in a usual format - and to get the labels adjusted automatically?

(view in My Videos) dt = Open( "$SAMPLE_DATA/Aircraft Incidents.jmp" ); d...
hogi

Discussions |
Jan 21, 2024 2:33 AM

848 views | 0 replies
Custom Binning - how to edit Transform Column settings?

In Jmp16, Custom binning was introduced: Interactive Binning - New in JMP 16 Very useful, thanks a lot to the developers! There are 3 ways (or more?) to use this feature:In the data table, via the menu: Col/Utilities/Make Binning Formula ...
or via right click / New Formula Column/Distributional */Custom Binning ...

for plot modes like Overlay, Color, X/Y Group, Page:
via right click/Levels/Custom L...
hogi

Discussions |
Jan 19, 2024 10:50 PM

671 views | 0 replies
Data Table for Multiple Users

Hi JMP Community, I created a data table that will used by a few colleagues to update table rows with new weekly data and to pull charts & graphs from. The file is stored on a SharePoint folder so we can all access it. The problem is if one user has the file open and another user opens the file, it will create a copy with that users computer ID.

Is there a way for multiple users to access this file...
CTrahon0526

Discussions |
Jan 19, 2024 9:45 AM

789 views | 0 replies
GraphBuilder Legend hook

There are many useful instances of being able to have a hook onto the selection state change of a legend for a chart / graph. With the non graph-builder method of generating charts' and graphs' legends (using Row Legend()), this was quite simple as the display element was simply a Table Box() that can receive a Set Row Change Function() message. The same cannot be done (to my knowledge) with Gra...
ErraticAttack

Discussions |
Jan 17, 2024 6:41 PM

657 views | 0 replies
Open files from same directory for Workflow

Hello Community, I only just recently started working with JMP Workflows and JSL Scripts and was wondering to create something in code to achieve the following: - The goal is to move a workflow (copy/paste) to a specific folder, where other files like .xlsx and .csv are located. The designed script should then open a specific .csv file from within the same folder the script or workflow is located ...
Gab_K

Discussions |
Jan 15, 2024 12:01 PM

736 views | 0 replies