Tiny Traps in Jmp and JSL

[#1]

JMP has 1 million cool features which allow the user to analyze the data at warp speed.
There are just a few tiny traps. They are less annoying for users who know where they are hidden.
→ Let's make a map! - and stay away from the dangerous places.

[More Topic Containers like this one]

Topic:	additional info	v18	V19
Graph Builder and Reports
Graph Builder + multiple response + multiple histograms	TS-00034150 actually, not just an issue with histograms ...	X	X
not possible to create plots with same size of the plot area (e.g. for export to PowerPoint + smooth transitions from page to page)	Graph builder Frame size JSL TS-00076249	X	X
In Jmp it is not "as easy as" in Excel to overlay plots from different columns / data tables	workaround	X	X
the colors in Graph Builder differ from the color settings in other platforms	workaround: use another color scheme, e.g. JMP Blue Red Green	X	X
The size of xGroup/yGroup/Wrap labels can NOT be changed interactively.	to cycle through differet size settings, use  on the   Graph Builder Toolbar	X	X
Graph builder - Summary Statistics not possible for multiple X values	workaround: For each column, manually add a separate plot element.	X	X
bug when selecting blocks of entries in the legend	https://community.jmp.com/t5/Discussions/Some-Tricks-with-Parallel-Y-Axes/m-p/913495/highlight/true#...	X	X
Data Tables
Collisions when several users work on a file stored in Sharepoint.	Optimize Sharepoint Integration	X	X
blocked data tables: it's not possible to sort a table, to concatenate tables or to add rows if a linked subset or a report is open	Sort data table + add rows + concatenate -> make it possible	X	X
some platforms don't allow pivate(0)	TS-00127556 Private yes/no?	X	X
formula column with contains doesn't get updated Differentiate between entire column and current row	TS-00053745 what's the reason behind this issue?	X	X
When a column data type is changed, e.g. from character to numeric, non matching entries get lost	Retain data when column data type is changed	X	X
Text to Columns differs from Text to Columns in MS Excel: groups of separators are treated as a single one -> empty data leads to shifted data (!)	Text To Columns: handle missing data correctly [actually, the Jmp version is also very useful!]	X	X
Tables/Update: speed issue	TS-00053519	X	X
A collision between localized/translated column names and default column names can lead to a  funny issue with column names	TS-00176113	X	X
no PRIVATE option for MFI	Private tables with Multiple File Import function Private option for Import Multiple Files	X	X
Application Builder
application builder: dangerous if data table is closed		X	X
JSL
COl N Unique() expects a column as first argument. This requirement is not there for other Col ... functions.	TS-00216935 doesn't work: New Column( "bug1", Formula( Col N Unique( Col Max( :height, :age ) ) ))		X
other bugs of Col score & Col N unique (in combination with Scoping)			X
The Where() and  Contains() functions are not compatible	https://community.jmp.com/t5/Discussions/Select-rows-where-column-values-match-items-in-an-arbitrary...  TS-00225505	X	X
JSL Debugger: doesn't show local variables	Function locals in JSL Debugger	X	X
JMP Expr() weirdness, can anyone explain?  inserting an expression into the same kind of expression flattens the expression	TS-00076135 Insert Into: Flatten(0|1)	X	X
When column names are changed, table scripts get updated automatically (so cool!!!) - but other scri...	catch "missing column" error and provide a selection menu delete column: safe mode	X	X
By default, the first >full<  Week of Year(...)  is #2 - and in 2023, the last one was #54. --> use	Calculating-WEEKOFYEAR-for-weeks-that-start-on-a-day-other-than/m-p/714426/highlight/true#M89773	X	X
Informat("XX.YY.year") and File import (!!!) assume "month.day.year" for XX.yy.zzzz with xx ≤ 13 (!)	The Doctor Cures  Your Date and Time Import Problems for informat, use Format Pattern option! for file import, vote here:  CSV import force MDY or DMY date format	X	X
Date Increment converts missing to 0! Date Increment(., "Week", 0) = 01Jan0000;	harmful because Graph builder uses this trick for its date binning:   TS-00147884	X	X
Display Tree Indexing - how does it work?
Returning an expression from a function differs when namespace is used.	TS-00235515 TS-00235798	X	X
Namespaces
Namespaces and Projects	root variable to globalize the namespace + local variable to get access from within a project	X	X
is namespace() is 1 for deleted namespaces namespace exists(ns) is 1 even if ns is no namespace	Fatal JMP16 bug	X	X
Formula Column + Namespaces re-evaluation is triggered every time a cell is selected.	Workaround:  What makes the formula evaluate over and over?	X	X
Jmp in general
Do you use the preferences?  ... it can lead to unpredictable results	TS-00043014	X	X
PickFile(), Projects and Network Drives  -> slow!	TS-00128387	X	X

old traps which got fixed in the meantime:

 JMP - New Features and Release Notes 

Graph Builder	fixed in Jmp
How to show the actual range in the level values in Graph Builder?	v17.2
How to apply changed properties to the Report?	v18
Graph Builder: reverse scale	v18
Local Data filter + Animation - how to specify the range?	v18
Heatmap: color for Missing Values?	v18
Graph Builder + Local Data filter + Multiple Response:adjust the axes to the filtered data TS-00044559	v18.1
get legend items: no scriptable objects	v18.2.2
Data Tables
Multi File import: add a fast mode	v18
get rows where: speed issue	v18
reference gets lost even if  data table doesn't get closed TS-00076052	v18
Find - or not find?  did you know that Ctrl + F doesn't work in almost 50% of the cases?	v18.1
JMP jumps... after copy column/ paste column TS-00127922	v18.1
Why-does-selecting-deselecting-rows-trigger-column-formulas	v18
2 (tiny) issues with grouped columns - one cannot move a column to the top of a column group   (fixed in JMP19) - a new formula column is generated outside of the group	v19
Why is Tables/Concatenate so slow?	v19
Multi File Import - File List has to be evaluated (Name filter gets automatically evaluated) further info	v19
Conflict of Compact Columns and linked tables summary table with a compact column	v18.2.2
Edit binning Formula for dates: cutpoints in seconds https://community.jmp.com/t5/Discussions/I-want-to-create-a-column-that-split-dates-into-quot-Before...	v19
Data Filters
A data filter ignores all changes of the data table if "conditional" is used TS-00049919	v17.2
A data filter doesn't get updated when the column name or data type is changed TS-00053718	v18
A Data Filter gets reset if there is no row in the current data table which matches the filter setting.  Outlier (:alien:) screening with Jmp Dashboards - how? v19::folded_hands: Column Property: Inclusive Values	v19
Tabulate
Color setting for highlighted text in Tabulate	v17
JSL
Bug when using combination of set each value, tables with same column name(s) and col statistical fu... fixed: Col Rank	v18
Bug when using combination of set each value, tables with same column name(s) and col statistical fu... not fixed yet: Col Sum similar bug with formula column: How does JMP evaluate a column formula?	v19
virtual link with a wrong table reference	v18.2.2
col max(if(string comparison))  Tips and Tricks - best practice with JMP/JSL	v19
additional  JSL code is executed before a column formula is finished. in the log << run formulas () is added automatically	v19
Python
Python data access --> speed issue caused by collision with JMP "interactivity" Python in JMP: dataframe column to datatable column best practices and computation speed implication...	v19.0.3
JMP in General	v19
Interactive HTML - catch problems	v19

[#2]

Actually, I think a community post is not the right place to do this, but it's a place to start.
If we keep it slim: just links to other community posts, I will try to add such links to the list on top.

Maybe we need something more professional than a community post with links?

- option to discuss individual topics (for now, please do this in the linked post)

- option to sort and restrict the list (e.g. select just Table issues > Jmp v17.1)
- possibility for more / (all ?) user to edit the list

[#3]

I think it is still good to have someone summarize/recap the discussion (that's how I learn of certain things that may not be an interest now but can be useful for future projects).

So I have to thank your effort here.

[#4]

Great work, Holger @hogi  :)

[#5]

with JMP18.1, some of the issues got fixed : )

[#6]

Some more issues were fixed with JMP19. : )

[#7]

nice improvement in JMP19:

issue: additional  JSL code is executed before a column formula is finished.
JMP19: in the log << run formulas () is added automatically. -> automatically generated code is robust against this issue.

[#8]

JMP 19.0.3

Bugfix for:
Python data access --> speed issue caused by collision with JMP "interactivity"
Python in JMP: dataframe column to datatable column best practices and computation speed implication...