Filtering "not unique" - is it possible?

Please, is it somehow possible to filter only “not unique” text strings? Let’s say I have a people database of 2500+ records, where first column (data field) is a single text type with “Name Surname”. I would like to filter out only records where Name Surname are the same (identical), just to find duplicities. In a footer I have set the parameter to “Unique”, so I see that I have 7 duplicities. Now, I would like to find them as fast and simply as possible. Thanks.

obrazek

Hey Marcus, unfortunately, currently it’s not possible to filter by footer aggregations. However, I’ll add this idea to the list of feature requests.

Please check out this thread for a workaround using automations to find duplicates: Remove duplicates.

Hello @marcus, we have discussed this request with the team, and we think it will be even more useful if we add the possibility to filter by unique and non-unique values. What do you think about this idea?

How would it work? You will just add the conditions “is unique” and “is non-unique” for all field types where it makes sense (at least text-type field, but maybe others too)? If yes, then sure it will be helpful, especially when seeking for duplicates. :+1:

Yep, we will introduce two new filters: one to only show values that are unique, where only one exists in the table, and the non-unique one to show values where there are at least two occurrences in the table.

Wonderful!!! This will make the duplicity search a lot easier.
That should be related to one (any) field. Or optionaly checkbox to match the non-unique value for the whole row (all fields in the row) - but this one (checkbox) is I believe not as much necessary/important.