group by excluded()

[hogi]

☐ cool new feature
☑ could help many users!

☐ removes a „bug“

☐ nice to have

☐ nobody needs it

By default, column formulas include "excluded" rows in the calculation.

An easy solution is to add "excluded()" explicitly as a group by option:
Exclude data in formula 

My wish:

a option in the  New Formula Column context menu:

more wishes submitted by  

[mia_stephens]

Thank you for this suggestion @hogi. It has been submitted for consideration.

[SamGardner]

@hogi looking at this solution that was posted previously:  Exclude data in formula   Is that a sufficient solution to this issue?  

[hogi]

Hi @SamGardner

The previous post is great: it explains how the problem can be solved in JSL.

This wish was triggered by the original post - but it goes beyond just a "solution".

A user of the current version of jmp still has to find out that something goes wrong, search the community and find the correct post.

Even then the user 

- has to be aware of the issue *)

- has to know how to fix it

- has to fix it manually

whenever he wants to add a column via "new formula column".

All these 3 topics could be addressed by adding a "group by excluded()" option to the "new formula column" menu.

*) first-time users could get aware by a short popup that explains the background:

[SamGardner]

Looking at the problem you have described, the main issue is that column formulas that calculate summary values from other columns do not respect the excluded row state, and we need a better and more obvious way to enable the user to be able to do that.  

[hogi]

any news here?