is it possible to make a view which is filtered according to an aggregate amount ?
For example I want to find duplicate documents according to filename and 2 other 'meta data' columns.
I make a summary view grouping by filename, meta colum1 and meta column2 and calculate # records. This works OK and gives me the calculation I need but I cannot limit the rows to only where #records > 2
You cannot even sort according to number records so only option is export to excel and filter # records >2 - surely theres a better way than this ?!
any suggestions ?
ID 1236
Category TeamDesk
Author Nick Ashcroft
Date Created 11/7/2018 8:37:51 AM
Date Updated 11/7/2018 9:14:23 AM
Comments
Nick Ashcroft 11/7/2018 9:14:23 AM
I tried the solution as suggested here https://www.teamdesk.net/find_duplicates with a many to many relation to itself but the view gave a time out error and everything became slow on that table (only 1000 records) so I had to remove it :-(
