topic Re: Tables / summary in Discussions

hide empty groups in Tables / summary

hogi — Wed, 14 Feb 2024 22:14:18 GMT

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

Re: Tables / summary

jthi — Wed, 15 Nov 2023 21:59:50 GMT

Maybe enabling "Remove Excluded Groups" in summary would work?

Re: Tables / summary

hogi — Thu, 10 Jul 2025 19:51:39 GMT

good idea ...:)

Re: Tables / summary

hogi — Wed, 14 Feb 2024 07:56:00 GMT

Unfortunately, the "Groups" in just refers to rows, not to Subgroups:

Re: Tables / summary

hogi — Thu, 10 Jul 2025 19:52:57 GMT

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/idc-p/764744/highlight/true#M5597