Use Group Count in Formula

1

Hello!

Is there a way hide a group if the count is over a certain number? Or use the group number in any way?

So the group EventName has a count of 120, so I’d want to hide that all those rows. Is that possible?

image
image708×612 33.4 KB

2

Hey there! You totally can do so

I would use a formula something like this:

image
image1196×406 25.5 KB

In my example, Eye Color was the column I was grouping and wanted to hide. You can view that document in action, see its formulas, etc below!

3

Thanks Scott. Could you elaborate on what exactly is happening in this formula? I’ve tried to use it, and tried a few different variations on it, but it keeps either not working or giving me an error.

thisTable.Filter(EventName=thisRow.EventName).Count()=120

This is what I’m using, but it ends up hiding everything. I’m not sure if this is an issue due to the fact I have two groupings (Date & EventName), or maybe because I’m applying the filter to a view and not the original table?

4

Hey Sam! can you share a copy of the doc? Or a paired-down copy of your document so I can help you trouble shoot?

Much easier to see what is going on that way!