Re: Formula Editor: meaningful results with excluded rows - Status changed to: AcknowledgedThank you for submitting this idea, @hogi!
Re: Formula Editor: meaningful results with excluded rowsadd-on wish:
What inspired this wish list request?
If
- there are rows excluded in a table
and - Col ... aggregation Expression don't have Exclude() as GroupBy option
(e.g. because the formula was auto-generated via the right-click New-Formula-Menu),
... it's quite likely that the results of the formula are wrong.
What is the improvement you would like to see?
If 1 + 2,
please add a warning message to the preview area in Formula Editor which informs the user that
- there are rows excluded in the table
and - Col ... aggregation is missing Excluded() as GroupBy option
--> 3. it's quite likely that the results of the formula are wrong.
Please also add a button to auto-correct the issue (i.e. add Excluded() as GroupBy option of the the Col ... Aggregation Expressions).
Why is this idea important?
A new Jmp user doesn't expect that such expressions have to be added to the formula.
The warning message will make him think, dig deeper and find out.
The button will enable him to auto-solve the issue without digging deeper.
Re: Formula Editor: meaningful results with excluded rowsA new Jmp user doesn't expect that such expressions have to be added to the formula:
Re: Formula Editor: meaningful results with excluded rowsWhy is my column mean not matching with one calculated via the distribution platform, after excluding row(s)?
Re: Formula Editor: meaningful results with excluded rowsExclude data in formula
Re: Formula Editor: meaningful results with excluded rowsJMP10: Col Max() and Col Min() functions returned the data from excluded row
Formula Editor: meaningful results with excluded rows☐ cool new feature
☑ could help many users!
☑ removes something that feels like a bug
☐ nice to have
☐ nobody needs it
What inspired this wish list request?
Unlike plots and reports, column formulas don't use the information: which rows are excluded? - by default.
If the user doesn't pay attention, this leads to erroneous, Max, Min Rank etc. values.
The workaround:
The user has to specify explicitly that excluded rows have to be excluded form the analysis.
Therefore some kind of Excluded() has to be added to the formulas as soon as rows are excluded:
Col Functions and Row States
The problem: The user has to know about the problem.
What is the improvement you would like to see?
- Please provide a shortcut button to add excluded()to the formula; The button could be placed between the columns list and the constants/variables menu.
- alternative:
For new users, please add Excluded() from Function List /Row States to the functions favorites
- to present it nicely visible at the top of the functions list.
Why is this idea important?
a) With the new button (or function favorite) a user can quickly add an excluded() expressions to his formula.
b) A new Jmp user doesn't expect that such expressions have to be added to the formula.
The availability of the button (or function favorite) will make him think, dig deeper and find out.
more wishes submitted by 
Data Blending and CleanupRe: Formula Editor: meaningful results with excluded rowssimilar wish: Option for formulas to ignore excluded rows
Re: Formula Editor: meaningful results with excluded rowsscoping is a wonderful new concept in JMP 19.
It could be used to fix the issue described in this post.
