The new possibility to use a Data Filter in Tables/Summary is very useful. Thank for adding it :)
One of the simplest application cases: calculate the summary for some groups, e.g. mean height just for some selected ages.
What hurts a bit: the excluded groups are still listed in the summary table, with 0 rows - and "missing" aggregated values.
I understand that the Data Filter in Tables/Summary is much more versatile than the simple application of: use exactly the column in the data filter which is also used as Group - to restrict the groups to some specific ones.
But this is a very nice application :)
Is there an option to hide/remove the filtered -> empty groups already when generating the summary.
easy workarounds:
- restrict the dataset by creating a subset (then one doesn't need the cool new Data Filter in tables/summary)
- select rows with N Rows = 0 and remove them
- select excluded rows and remove them
Maybe enabling "Remove Excluded Groups" in summary would work?
vs
good idea ...:)
Unfortunately, the "Groups" in just refers to rows, not to Subgroups:
submitted by @shampton82 as a subtopic of this wish:
https://community.jmp.com/t5/JMP-Wish-List/Handling-Hidden-Excluded-rows-columns-in-Table-handling/i...