JMP User Community

Latest Discussions

Setting multiple rows in a single column to a single value

Hello, Noob question... I have a column with a unique identifier (UID) for certain types objects, for instance {'cats', 'dogs', 'birds'}. Each UID has multiple rows associated with it, which I have captured in an associative array.Example: aa = { 'cats' => [1, 2, 3], 'dogs' => [4, 5, 6], 'birds' => [7, 8, 9] }For each UID, all rows associated, I need to set a different column (col2) to a single va...
StarfruitBob

Discussions |
Aug 1, 2023 8:54 AM

5235 views | 7 replies
creating new columns with a for loop with column names and formula

I am trying to create a split table from an existing table and add new columns into the split tables each with a formula based on the columns that were split. However the code creates the new columns but gives me "Formula evaluation errors" dt2 = Current Data Table(); // Create the split data table dt2 = dt << Split( Split By( :S ), Split( :Name( "Median(data)" ) ), Group( :L, :m, :C, :...
FrequencyBison9

Discussions |
Aug 1, 2023 8:48 AM

2265 views | 4 replies
Why do the colors of different other points fade away in Graphbuilder?

Hello, I have been able to work on a script to edit the legend, based on a Flag column. When I recreate the same plot in GraphBuilder, I get a darker shade of colors, but when I run my script, it gives me a faded shade than normal. Why is this? I know it is something related to rows being selected, and the GraphBuilder just highlights those rows or cells. I have tried incorporatingdt << Clear Colu...
Kenobi

Discussions |
Aug 1, 2023 4:46 AM

1838 views | 2 replies
I am trying to plot bivariate of the new columns created but having issue creating another list.

dt = Current Data Table(); //declaring variables alpha_min = 14; alpha_max = 18; inc_val = 0.1; this is the script, but i want to create bivariate plots of each of them without it showing up as multiple pages and also combine the reports to data table. thanks :) //defining mu col names mu_col = "mu"; //loop through alpha range and create new cols// For( alpha = alpha_min, alpha <= alpha_max,...
ParametricStudy

Discussions |
Jul 31, 2023 11:30 AM

1920 views | 3 replies
Auto exclude a certain item from the legend

Hello, I am trying to create a GraphBuilder plot, with a "Flag" column being used in the "Color" section as show below I want my script to autoexclude a particular category, lets say "PASS" in this case. I am not sure on how to do that. Any suggestions would be very helpfulThank you.

For(i = 1, i <= N Items(y_cols), i++, y_name = Char(y_cols[i]); x_name = Char(x_col[1]); gb = dt << Graph Build...
Kenobi

Discussions |
Jul 31, 2023 7:01 AM

1703 views | 2 replies

Previous
Next

Latest Discussions

I am trying to plot bivariate of the new columns created but having issue creating another list.

dt = Current Data Table(); //declaring variables alpha_min = 14; alpha_max = 18; inc_val = 0.1; this is the script, but i want to create bivariate plots of each of them without it showing up as multiple pages and also combine the reports to data table. thanks :) //defining mu col names mu_col = "mu"; //loop through alpha range and create new cols// For( alpha = alpha_min, alpha <= alpha_max,...
ParametricStudy

Discussions |
Jul 31, 2023 11:30 AM

1920 views | 3 replies
Workflow builder and referencing

Hi everyone,I'm trying to build a workflow that will allow be to quickly look at numerous csv files that all have the same format, number of variables, column names etc. I didn't think it would be that complicated but I'm having trouble with the referencing. I've attached an example file (a deconstructed quantitative mass image with x, y pixel locations and mass counts at each pixel). I first bin ...
GregMcMahon

Discussions |
Jul 31, 2023 3:48 AM

2913 views | 4 replies
Giving options for user to select from, storing selection as string

Hi, here's my current code that displays a popup window for user input. I want it so that for Level:, they can choose between two options (each option having a box next to it that the user can tick to select one). What would I have to add to my code to get that? Here's a picture of what I want the "level" user input to look like:Where the user can select one or the other before clicking "Save." ...
aidanweb

Discussions |
Jul 29, 2023 7:51 PM

1008 views | 1 replies
Delete consecutive repeating values

I have a data table where some of the columns have values that repeat because the program that generates the data holds the last value if a new one isn't given. This means I can't use the "select duplicate rows" option because that deletes all duplicates not just ones that are repeating. I also don't want to delete the rows, just the values in the "cells". 4.13.43.4 - delete value3.4 - delete val...
JMPtxUser36

Discussions |
Jul 28, 2023 10:30 AM

1450 views | 2 replies
Challenges constructing a proper loop

Hi, Im new to coding and having challenges constructing a functioning scriptdt = current data table(); //declaring and initializing variables// lt_min = 1; lt_max = 50; RSquare_th = 0.9999; count = 0; //loop while (count < 0.99999, //calculate x for each y value dt << New Column ("x", Numeric, formula(:y/ (:y + :avg_num))); //plot bivariate biv = dt << Bivariate( Y( :x ), X( :average_temp),...
ParametricStudy

Discussions |
Jul 28, 2023 7:53 AM

1122 views | 1 replies

Previous
Next

Latest Discussions

How to use JSL of JMP software to find the one that is more suitable for sinusoidal curve from multiple sets of data?

Hello!For example, using large class data:
Compare the height column and the weight column to see which column fits the sinusoidal distribution better.
The parameters of the sine curve are random. Thanks!
UersK

Discussions |
Jul 24, 2023 11:44 PM

804 views | 0 replies
bounded KDE (Kernel Density Estimator)?

Has anyone created or heard of function for JSL that returns a bounded KDE (Kernel Density Estimator)? I'm aware of the KDE used inside of the distribution platform, but one is not able to provide bounds to the domain.
Prokaryote

Discussions |
Jun 23, 2023 11:56 AM

930 views | 0 replies
How to set Scale Values in Graph Builder use Col Quantile function?

HI, I want set Scale Values in Graph Builder use Col Quantile function, but always something wrong. the red code have some problem. I need color scale as Quantile Graph Builder( Size( 839, 726 ), Variables( X( :Prober_X ), Y( :Prober_Y ), Color( :OpticalPower ) ), Elements( Points( X, Y, Legend( 6 ) ) ), SendToReport( Dispatch( {}, "400", ScaleBox, {Legend Model( 6, Pr...
Solarwing

Discussions |
Jun 20, 2023 9:32 AM

786 views | 0 replies
New Series on JSL and Visual Code Studio

Just a heads up that we've been posting some additional JSL tricks on our LinkedIn Blog. We have a weekly series that's been running currently focused on our Visual Code Studio Extension for JMP. Week 1: https://www.linkedin.com/posts/predictum_automationjmp-series-use-vs-code-extension-activity-7062456347543359488-uzFu?utm_source=share&utm_medium=member_desktopWeek 2: https://www.linkedin.com/...
wjlevin

Discussions |
Jun 19, 2023 2:26 PM

1223 views | 0 replies
Overlaying histograms: Iterating a function through N number of columns?

@PatrickGiuliano , As a response to our latest discussion : Re: How to overlay histograms in JMP Thanks a lot for the response. Also, 1) I would like to get more guidance on ' possibilities of iterating the Overlap function for more columns ( N number of Columns), if possible. the code for : Y Function(N, x): can be iterated ? Y Function(N, x);
For(i = 1, i <= N Col(xm), i++,
ym[i] = Min(Normal D...
DecileDromedary

Discussions |
Jun 19, 2023 6:31 AM

700 views | 0 replies