JMP User Community

Latest Discussions

Inconsistent acceptable syntax

AllCols = dt << Get Column Names(); AllColNames = dt << Get Column Names(string); for(i=3, i<=n items(AllCols), i++, colcol = AllCols[i]; cname = AllColNames[i]; nnm1 = Col Number(colcol); Fstr = "num(:\!""||cname||"\!"n)"; Fexpr = parse(Fstr); newcol = dt << new column("Temp", numeric, formula(eval(evalexpr(Fexpr)))); nnm2 = Col Number(newcol); if(nnm2 == nnm1, newcol << delete formul...
pcarroll1

Discussions |
Nov 15, 2024 12:18 PM

4376 views | 14 replies
How can I arrange column names in JMP file in alphabetical order (ascending and descending)?

HiIs there any method in JMP Pro that can arrange the column names in alphabetical order (ascending and descending)?I have named the variables by acronyms only (see examples below).ACCMLAMEBIs both the insured driver [you] and other driver jointly to blame for this incident? Yes/No 2ACCMLAMEBRIf Yes/No, why? Give justification [in texts] between 50 and 100 words 3 DAMVICSIDEDamage to vehicle/Point...
madhu

Discussions |
Nov 14, 2024 8:35 PM

2943 views | 5 replies
Workflow Builder - For Loop

The animations in Workflow Builder are nice to look at.
Like with the animations in Excel: nice, but they add quite a delay!
Is there a trick to disable the animations to speed up the processing ? (view in My Videos)
hogi

Discussions |
Nov 14, 2024 6:43 AM

1009 views | 2 replies
Missing P Values in Effect Summary OF Fit Model

Hi, I am using JMP-14.I was using Fit Model and somehow my Effect Summary Dialogue is missing Data, no P-Values for the data.Is there a reason why this would happen?Thanks in advance
RBAero

Discussions |
Nov 8, 2024 4:48 PM

7586 views | 9 replies
Toggle button box or something similar

Hi JMP Community, I'm trying to set up a window where users can select different months, or quarters, or the entire YTD, that also provides feedback of which button boxes have been selected (or even deselected). My intent is to ultimately use the month/quarter/YTD selection as a way to create a subset of a data table based on the month (year is always set to current year for now). Here's a...
SDF1

Discussions |
Nov 6, 2024 7:41 AM

2971 views | 7 replies

Previous
Next

Latest Discussions

Inconsistent acceptable syntax

AllCols = dt << Get Column Names(); AllColNames = dt << Get Column Names(string); for(i=3, i<=n items(AllCols), i++, colcol = AllCols[i]; cname = AllColNames[i]; nnm1 = Col Number(colcol); Fstr = "num(:\!""||cname||"\!"n)"; Fexpr = parse(Fstr); newcol = dt << new column("Temp", numeric, formula(eval(evalexpr(Fexpr)))); nnm2 = Col Number(newcol); if(nnm2 == nnm1, newcol << delete formul...
pcarroll1

Discussions |
Nov 15, 2024 12:18 PM

4376 views | 14 replies
Workflow Builder - For Loop

The animations in Workflow Builder are nice to look at.
Like with the animations in Excel: nice, but they add quite a delay!
Is there a trick to disable the animations to speed up the processing ? (view in My Videos)
hogi

Discussions |
Nov 14, 2024 6:43 AM

1009 views | 2 replies
Missing P Values in Effect Summary OF Fit Model

Hi, I am using JMP-14.I was using Fit Model and somehow my Effect Summary Dialogue is missing Data, no P-Values for the data.Is there a reason why this would happen?Thanks in advance
RBAero

Discussions |
Nov 8, 2024 4:48 PM

7586 views | 9 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
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

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