TeamDesk Knowledge Base & Support

   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 ?

Nick Ashcroft
Date Created
11/7/2018 8:37:51 AM
Date Updated
11/7/2018 9:14:23 AM
Nick Ashcroft 11/7/2018 9:14:23 AM
I tried the solution as suggested here 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 :-(
Back to Search Results