Home      FAQ      Forum      Idea Exchange      Ask a Question      My Stuff      Help   
  
Conditions on aggregate amounts
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 :-(
Feedback
Back to Search Results