When using the Table-processing commands, it would be helpful to provide checkboxes in the dialog to determine how to handle hidden / excluded rows or columns. In particular, this is problematic with splitting tables.
If there is a good reason why summary respects excluded - there could be a similar reason why the other platforms should respect it as well (at least for some cases).
If there is a good reason why a platform doesn't respect excluded - there could be a similar reason why summary shouldn't either (at least for some cases).
Yes, please add a yes/no >option< to ALL Table platforms ... to respect excluded (for split, stack, update ...) ... and if you wish: to disable it for summary
Alternative:
please add an option to store the excluded state in an additional column (many column in the case of split).
Alternative:
Please add a warning that the respective Table Platform is one of those which ignore excluded (e.g. as a option in the platform: "respect excluded" - an option which is disabled or: as status text on the bottom left)
It's clear that the user just has to generate a subset of the non-excluded row. so ... Why is this idea important?
Due to table linking - the user gets a visual feedback that Tables/Summary does respect "excluded":
Current Data Table() << Data Filter(
Add Filter(
columns( :age ),
Where( :age == {14, 17} )
));
So, it's not obvious that the other platforms ignore "excluded" - and it's hard to find this info in the Documentation.
Another point for this request is to have the ability for the filter in the Summary platform (or any other platform that ends up using it in the same way) to respect the "Subgroup" and not just the "Group" levels. What happens now if I want to only have a certain level/s of a column in the "Subgroup" I have to subset the data then do a Summary as the filter doesn't apply to the "Subgroup" columns and so I get a column for all the levels in the Summary output, even if I had used the in platform filter in to try an exclude them. Very frustrating as the filter is taunting you for the "Subgroup"!