JMP User Community

Latest Discussions

Is Missing( " " ) returns True?

I would like to differentiate a space cell and an empty cell. The Is Missing() function interprets both as missing. Is there a better way? I am using JMP 16.2.0. New Table( "Example", Add Rows( 1 ), New Column( "Empty", Character, "Nominal", Set Values( {""} ) ), New Column( "Empty Missing?", Numeric, "Continuous", Format( "Best", 12 ), Formula( Is Missing( :Empty ) ) ), New Column(...
robot

Discussions |
Nov 6, 2024 2:26 AM

3736 views | 6 replies
How to create a "revolving" x-axis in JMP?

Curious if there's even a way to do this in JMP.... I need to modify my x-axis to where I start off with an arbitrary number (ex. -77), increases to say, -111 in the middle of the axis, then returns back to -77. The problem I'm having is that my data includes multiple configurations and occasionally, within one configuration data set, I'll have the same x-value even though it's two separate data p...
SelectionEagle6

Discussions |
Nov 5, 2024 1:47 PM

1798 views | 2 replies
Hex to Binary

I have a HEX number that I want to convert to binary. I can do this manually for one hex at a time from this website (Hex to Binary Converter), but I can't figure out how to do this in jmp. Example from the web: My attempt in JMP: HEX2BIN formula:Any guidance would be much appreciated. Thanks! Links that haven't helped so far: Hexadecimal and BLOB FunctionsAll your base are belong to usRe: How to...
data_nerd

Discussions |
Nov 5, 2024 11:05 AM

2315 views | 4 replies
Formula for change over time

Looking for a formula to access change over time at a row level moving from left to right i want to assess the percent shift from the 1st reading to the next and then assess all following reading back against the first and the previous reading to access shift overtime. If any are downward shifts greater than or equal to 20% indicate a 1 in a result column.
DELANDJ1985

Discussions |
Nov 4, 2024 8:01 PM

825 views | 1 replies
comparing data in rows and naming according to column names

Greetings, I have a data set for which I would like to have a column formula that considers several rows, and then returns a name to the new column according to the row data, specifically the highest value among the selected rows. I would like the name returned to be the same name from those columns considered. Something like this, what would that formula be please? (Thank you ahead of time f...
jackpdavis

Discussions |
Nov 1, 2024 1:20 PM

1548 views | 4 replies

Previous
Next

Latest Discussions

How to create a "revolving" x-axis in JMP?

Curious if there's even a way to do this in JMP.... I need to modify my x-axis to where I start off with an arbitrary number (ex. -77), increases to say, -111 in the middle of the axis, then returns back to -77. The problem I'm having is that my data includes multiple configurations and occasionally, within one configuration data set, I'll have the same x-value even though it's two separate data p...
SelectionEagle6

Discussions |
Nov 5, 2024 1:47 PM

1798 views | 2 replies
Formula for change over time

Looking for a formula to access change over time at a row level moving from left to right i want to assess the percent shift from the 1st reading to the next and then assess all following reading back against the first and the previous reading to access shift overtime. If any are downward shifts greater than or equal to 20% indicate a 1 in a result column.
DELANDJ1985

Discussions |
Nov 4, 2024 8:01 PM

825 views | 1 replies
Recode - Parse as Numbers

Why does Recode not show a warning when a user uses the "parse as number" option?
hogi

Discussions |
Oct 30, 2024 1:16 AM

1198 views | 3 replies
Error add-in manager :AddinID == selectionID

I am taking the above error once i click to build currently selected add-in button at the add-in manager. Error Message: {"Send Expects Scriptable Object"(1, {23}, 2, "Send", here:addinTable << /*###*/get rows where(:AddinID == selectionID) /*###*/)} Error: Send Expects Scriptable Object 1 time(s). Data Table Indices: 23 Type: Error Function Name: Send Function being executed: here:addinTab...
Georgios_Tsim

Discussions |
Oct 29, 2024 6:41 AM

686 views | 0 replies
Mean differences Student's t Table as Dunnett's differences table.

HI! :) At the Fit Model output window we can take the mean differences of an effect. We can choose among various methods such as Student and Dunnett. The following is the output of the dunnett methodwhere the format of the diffs is : Batch - Control but the confidence limits are not the same as in the students case:So what I would like is to take the second table. The results of the student's di...
Georgios_Tsim

Discussions |
Oct 23, 2024 1:20 AM

1642 views | 4 replies

Previous
Next

Latest Discussions

Error add-in manager :AddinID == selectionID

I am taking the above error once i click to build currently selected add-in button at the add-in manager. Error Message: {"Send Expects Scriptable Object"(1, {23}, 2, "Send", here:addinTable << /*###*/get rows where(:AddinID == selectionID) /*###*/)} Error: Send Expects Scriptable Object 1 time(s). Data Table Indices: 23 Type: Error Function Name: Send Function being executed: here:addinTab...
Georgios_Tsim

Discussions |
Oct 29, 2024 6:41 AM

686 views | 0 replies
Machine data source list remove in "Database Operations"

I used "File"-->Database-->Open table-->New connection to setup some tables from DB. but I found my list for new connections becomes longer and longer. like the attached pic. I did not found there is a way that i can remove any items from the connection list. the question is that is there a way that i can delete them. Thanks in advanced. KRSean
Sean_ShCn0

Discussions |
Aug 22, 2024 7:24 AM

910 views | 0 replies
Is there a way to tell LCA that the rows are ordered by class?

Typical dataset: 120-200 rows, 15 classes. Rows are known to be ordered by class. What is unknown is where the 'fences' between classes are. As-is -- i.e., without taking row order into account -- LCA correctly classifies about 94% of rows. My intuition is that if I knew how to tell the algorithm that the rows are grouped by class on input, we'd be at 100%. Visual, in case my use of 'grouped by' i...
mtowle419

Discussions |
Aug 15, 2024 5:03 PM

659 views | 0 replies
I would like to find another political scientist or other social scientist who has worked with mapping congressional districts and counties

There are great bodies of data presented by counties (disease incidence, education, income). There are other bodies of data presented by congressional districts (incumbents, vote percentages, etc.) I want to find someone who has mapped the counties and the congressional districts into the same space. I know this can be done with ESRI products, but I wanted to avoid jumping off the JMP platform....
LNitz

Discussions |
Aug 8, 2024 8:15 PM

711 views | 0 replies
Overlying map files and merging content

I have two map files--one of economic and health conditions by US county. The other of congressional districts. I wish to overlay the county map on the congressional district map and attrribute the county measures to the ( larger opr smaller) congressional districts. For example, what is the average rate of coronary heart disease in districts represented by women versus those represented by m...
LNitz

Discussions |
Aug 1, 2024 2:04 AM

661 views | 0 replies