JMP User Community

Latest Discussions

Send Expects Scriptable Object in access or evaluation of 'Send'

I have the following function that is called by another jsl file: ConfirmFiltering = Function({}, show(dtImp); dtImp << Select Where(!Contains(parameterChoice, :Parameter)); );and even if the output of the show command is: dtImp = DataTable("Details 2");at the following line I get the following error:Send Expects Scriptable Object in access or evaluation of 'Send' , dtImp << /*###*/Select Where...
Georgios_Tsim

Discussions |
Jul 22, 2024 12:25 AM

2663 views | 5 replies
Selecting Cells based on color

Hello,

After running the outlier analysis tool in JMP, I color coded the cells that contained outliers. How can I select all these cells and replace them with the name, "outlier"? The next step, would be to name all the other cells "normal".

Let me know if this is feasible. A snapshot of the datasheet in appended in this post.
MikeDereviankin

Discussions |
Jul 21, 2024 10:05 PM

3241 views | 4 replies
is in spec(value)

For a column with property Spec Limits, is there a functionis in spec(:value)which compares the value of the current row with the spec limits of the column?

The best approach which I found up to now: let JMP color the cells and analyze the colors by @Neo
How to get the row number of colored cells in a column and assign it a tag (say "1") in a newly created column? A cool trick - but is there any d...
hogi

Discussions |
Jul 20, 2024 7:40 AM

2167 views | 4 replies
Table: sort by multiple columns?

How can I sort a table by multiple columns.

In a data table, when I select multiple columns and sort the table via right click: the table is always sorted from "left to right" - the sort column on the left is the dominant one
... even if I change the order in which I select the columns. Via JSL, I can adjust the order:dt << Sort(By( :sex, :age )); dt << Sort(By( :age, :sex ));How to do the trick ...
hogi

Discussions |
Jul 20, 2024 5:40 AM

1128 views | 1 replies
how to count the frequency of error code in a column in a data base

Hello,

I am trying to create a Pareto diagram in JMP, but in my data table, I don't have the frequency of code errors (which are defined as a list of integers from 0 to 1010). I am looking for a way to count these directly in JMP as a new column.
I found the "Row > Count" function in the formula section, but I don't know how to use it

Best regards,
Thank you.
Yass

Discussions |
Jul 18, 2024 7:51 AM

2283 views | 6 replies

Previous
Next

Latest Discussions

Selecting Cells based on color

Hello,

After running the outlier analysis tool in JMP, I color coded the cells that contained outliers. How can I select all these cells and replace them with the name, "outlier"? The next step, would be to name all the other cells "normal".

Let me know if this is feasible. A snapshot of the datasheet in appended in this post.
MikeDereviankin

Discussions |
Jul 21, 2024 10:05 PM

3241 views | 4 replies
Consumer Research > Choice Model Error

Hello, I am trying to analyze the following file. However, when I try to run the Analyze > Consumer Research > Choice Model. JMP throws the following error in the log. Row 476 has nonzero response indicator despite earlier row being the indicator for that group. Row 478 has nonzero response indicator despite earlier row being the indicator for that group. Row 453 has nonzero response indicator d...
Bhumika53

Discussions |
Jul 13, 2024 4:31 PM

2167 views | 1 replies
How does one perform Bitwise operations in JMP formulas?

Hi, I imagine this is simply an issue in which I am not finding the correct formula option but how does one perform basic bitwise operations in a JMP formula? e.g. Here's an example Python example that I would like to replicate in JMP: lambda x: ((((x>>1)&0x1))<<2) thanks, Ross
docrossus

Discussions |
Jul 11, 2024 3:18 PM

4579 views | 6 replies
Storing data tables as metadata (table variables) JSL

Table variables are used to store metadata within a data table (JSL doc, general doc) However, they seem to be limited to variables as strings only (see code below). What would be the best option to store a data table as a table variable? Names Default To Here( 1 ); dt = Open( "$SAMPLE_DATA/Big Class.jmp" ); dt_metadata = Open( "$SAMPLE_DATA/Solubility.jmp" ); dt << Set Table Variable( "dt_user...
FN

Discussions |
Jul 1, 2024 9:25 AM

2404 views | 6 replies
Randomized Complete Block Design (RCBD).

In a Randomized Complete Block Design (RCBD).¿What should I do if the assumption of no interaction between the interest factor and the block is not met?
CrhistianDoE

Discussions |
Jun 26, 2024 8:29 AM

1401 views | 1 replies

Previous
Next

Latest Discussions

change tick labels

There are several ways to change tick labels in Graph Builder.

New in JMP17: via Configure Levels. Before JMP17, one could use Value Labels: ... and there is a nice shortcut to apply them very quickly:
- click on a tick label and hold the mouse button for some while.- the axis will change to edit mode- edit the label- press ESC

thanks @laura_archer for this trick & explanation :)

(view in My Videos)
hogi

Discussions |
Jun 20, 2024 2:01 PM

879 views | 0 replies
How to categorize the same ID in row with other columns?

Hi, I have the data set that the same ID in multiple rows. Each rows had 1 to 3 categories. The columns represent costA to costZ that I need to stack in the same Cost column. However, I need to generate group by category 1 ( 1 if category 1 < 2000, 2 if category 1 = 2000 - 4000, 3 if category 1 = 4000 - 6000, 4 if category 1 = 6000 - 10000, 5 if category 1 > 10000). However, I need to delete categ...
doraemengs

Discussions |
Mar 25, 2024 9:12 PM

1170 views | 0 replies
RSS, TSS, precent of residual sum of squares

Is it possible to calculate RSS and TSS and precent of residual sum of squares for a linear calibration curve in JMP?
gholamhasantey

Discussions |
Mar 25, 2024 3:29 AM

1091 views | 0 replies
Is there a way to change the defaults for the Summary platform?

Hi All, Does any know if it's possible to change the defaults of the Summary platform (Tables > Summary)? By default, Summary sets the new column names to be stat(column) and checks that the new data table is linked to the original data table. For much of the work I do, I don't like these features and wish I didn't have to change them every time I run a Summary. I know it can be useful at tim...
SDF1

Discussions |
Feb 29, 2024 8:08 AM

745 views | 0 replies
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

1058 views | 0 replies