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
Graph Builder and Reports
Graph Builder + multiple response + multiple histograms	TS-00034150 actually, not just an issue with histograms ...
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
In Jmp it is not "as easy as" in Excel to overlay plots from different columns / data tables	workaround
the colors in Graph Builder differ from the color settings in other platforms	workaround: use another color scheme, e.g. JMP Blue Red Green
The size of xGroup/yGroup/Wrap labels can NOT be changed interactively.	to cycle through differet size settings, use  on the   Graph Builder Toolbar
Graph builder - Summary Statistics not possible for multiple X values	workaround: For each column, manually add a separate plot element.
Data Tables
Why is Tables/Concatenate so slow?	delete Files scripts - or merge them into one script TS-00173141
Collisions when several users work on a file stored in Sharepoint.	Optimize Sharepoint Integration
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
some platforms don't allow pivate(0)	TS-00127556 Private yes/no?
formula column with contains doesn't get updated Differentiate between entire column and current row	TS-00053745 what's the reason behind this issue?
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
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!]
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	TS-00035674
Tables/Update: speed issue	TS-00053519
A collision between localized/translated column names and default column names can lead to a  funny issue with column names	TS-00176113
Data Filters
A Data Filter gets reset if there is no row in the current data table which matches the filter setting.  Outlier (👽) screening with Jmp Dashboards - how?	TS-00046650 In the queue:🙏 Column Property: Inclusive Values
JSL
JSL Debugger: doesn't show local variables	Function locals in JSL Debugger
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)
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
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
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
Date Increment converts missing to 0! Date Increment(., "Week", 0) = 01Jan0000;	harmful because Graph builder uses this trick for its date binning:   TS-00147884
Multi File Import - File List has to be evaluated (Name filter gets automatically evaluated) further info	TS-00152969
Display Tree Indexing - how does it work?
Application Builder
Table reference is removed from an application if the data table is closed.	application builder: dangerous if data table is closed
Namespaces
Namespaces and Projects	root variable to globalize the namespace + local variable to get access from within a project
is namespace() is 1 for deleted namespaces namespace exists(ns) is 1 even if ns is no namespace	Fatal JMP16 bug
Formula Column + Namespaces re-evaluation is triggered every time a cell is selected.	Workaround:  What makes the formula evaluate over and over?
Jmp in general
Do you use the preferences?  ... it can lead to unpredictable results	TS-00043014
MS Teams and Sharepoint prevent interactive HTML pages from executing the scripts.	Interactive HTML - catch problems
PickFile(), Projects and Network Drives  -> slow!	TS-00128387

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
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 #1: one cannot move a column to the top of a column group	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
Tabulate
Color setting for highlighted text in Tabulate	v17

[#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 : )