Formula Editor: meaningful results with excluded rows

[hogi]

☐ 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  

[hogi]

add-on wish:

What inspired this wish list request? 
If

1. there are rows excluded in a table
   and
2.  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 

1. there are rows excluded in the table
   and
2.  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.

[Sarah-Sylvestre]

Thank you for submitting this idea, @hogi!

[hogi]

A (new) Jmp user doesn't expect that such expressions have to be added to the formula (he is used to the comfort of Summary, Graph builder, Tabulate etc.).

So  typical *) Jmp user will start generating Formula columns without excluded()GroupBy and after some while he will notice the error by chance - or he won't notice (!) over years.

 *) And then there are the nerds - who read the manual

[hogi]

Why is my column mean not matching with one calculated via the distribution platform, after excludin... 

[hogi]

Exclude data in formula 

[hogi]

JMP10: Col Max() and Col Min() functions returned the data from excluded row 

[hogi]

similar wish: Option for formulas to ignore excluded rows