Caution: Places where Jmp does something unexpected

[#1]

Definitely, JMP is Not a Spreadsheet . And that's great!!

Besides this difference, there are other places where Jmp doesn't do/behave/produce what a newbie / innocent Jmp user expects.

If a user knows these issues and the remedies and workarounds -  he/she can
a) save a lot of time

b) be safe from data loss

c) be sure that the results are as expected.

[More Topic Containers like this]

Topic	description	Links
Data Tables
Formula column + excluded rows	Unlike plots and reports, column formulas  don't use the information about  excluded rows. Workaround:  col mean(:height, excluded())	Formula Editor: meaningful results with excluded rows Compute Column Mean ...Col Max() ... excluded row Col Functions and Row States  Exclude data in formula
Source Scripts + Tables/Update	Tables/Update overwrites an existing Source script same issue for Concatenate + Append to first table	Update & Concatenate:source script collision workaround, @internal: use our bug-fixed Update platform it archives the source script before overwriting it
	Danger! Besides importing new data from an Excel file, the script resets ALL changes of the data table. (!!!)	Disable "Update Table" script?
issues with dates	JMP prefers M.D.Y  this can lead to issues with D.M.Y	CSV import force MDY or DMY date format
issues with decimal separator	file import: no setting for decimal separator neither via GUI nor via JSL	txt import - point and comma ?   Make decimal separator an option
Score unique & count unique	excluded rows are excluded from the calculation. values don't get updated after changing the row states	score Unique & count unique
Platforms
Query Builder + Formula Columns	Formula Columns get transferred to the result table, where they get evaluated again. Issues with dif(), Lag(), Col.. () aggregations ... !	Why is there such unexpected re-calculation of columns without formulas?
issue with excluded()	Some of the Platforms of the Tables menu produce their output ignoring the excluded() row state, others take the excluded() row state into account.	Handling Hidden / Excluded rows / columns in Table-handling
Tables/Split possible issue with Keep	Split merges multiple rows into a single row. "Keep" - which entry? the first one - can lead to surprising results:	Bad Stacking?
Scoring in Graph Builder	The graph doesn't get updated when row states are changed in the data table	score Unique & count unique
JSL
Jmp doesn't wait till a data table is fully processed when executing subsequent JSL code.	add wait() or dt << run formulas()	When to use Wait(0)?  Why is there an empty table if you don't add wait（）? run table script
Python
Python data access --> speed issue caused by collision with JMP "interactivity"	workaround till the issue gets fixed: jmp.globals['jdt'] = dt jmp.run_jsl('jdt << Begin Data Update;') ... jmp.run_jsl('jdt << End Data Update;')	Python in JMP: dataframe column to datatable column best practices and computation speed implication...
Graph Builder
Platforms in JMP accept fractional values as Freq : )	... Graph Builder doesn't	Freq and Weight: better documentation
Graph Builder + Heatmaps	there should be an option to disable the automatic adjustment of the axis increment	Heatmap - option: fixed Tick spacing (aggregation area)
Graph Builder + manually changed axis labels	Manual axis labels are mixed up when columns are added, removed or dragged to a different position	Manual axis labels are 'mixed up' when plotting multiple columns Bugfix is in preparation (JMP19)