cancel
Showing results for 
Show  only  | Search instead for 
Did you mean: 
Choose Language Hide Translation Bar
hogi
Level XI

hide empty groups in Tables / summary

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

 

hogi_0-1700083781426.png

1 ACCEPTED SOLUTION

Accepted Solutions
jthi
Super User

Re: Tables / summary

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

jthi_0-1700085551136.png

vs

jthi_1-1700085570980.png

 

-Jarmo

View solution in original post

3 REPLIES 3
jthi
Super User

Re: Tables / summary

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

jthi_0-1700085551136.png

vs

jthi_1-1700085570980.png

 

-Jarmo
hogi
Level XI

Re: Tables / summary

good idea

hogi
Level XI

Re: Tables / summary

Unfortunately, the "Groups" in hogi_1-1707897287115.png just refers to rows, not to Subgroups:

 

hogi_0-1707897233480.png