TeamDesk Knowledge Base & Support

   Home      FAQ      Forum      Idea Exchange      Ask a Question      My Stuff      Help   
  
Summary views - filter on calculated columns
in the summary view its possible to make an calculation such as count, sum, min, max etc of records.

Its possible to add a fiter on the records prior to this calculation. However, its not possible to filter on the calculation itself.

Please add the option to filter the aggregate/grouped amounts also - this is a akin to a 'having' clause in sql in addition to the 'where' clause which is already supported.

for example I want to find duplicate combinations of values in columns A,B,C

I group by A,B,C and the count records. The summary result is ok, but shows all rows regardless the count value. I want to be able to filter only records with count >1

thanks
ID
1282
Category
TeamDesk
Author

Nick Ashcroft
Date Created
6/4/2019 3:00:05 AM
Date Updated
6/18/2019 9:08:28 AM
Status
New Idea
Score
40
Promoted By
Philipp Matuschka (MMB)Jorge SoláPatricio Bustos
Nick Ashcroft
Comments
Jorge Solá 6/7/2019 7:42:53 PM
Hello, Nick.

I if understand well your example, you could try this workaround:

1) Create a Formula-Text column that combines A, B & C. Let's call it [A+B+C]. The formula can be something like: List(" ", [A], [B], [C])

2) Create a relation of this table to itself. Add these 2 matching conditions:
[A+B+C]=[A+B+C]
[Id]<[Id]

3) Create under this relation a summary column that counts the # of records. Let's call it [Count]. If the [A+B+C] value is duplicated in some of the records, the first one will have a value of 0, but the duplicates will have a value of 1, 2, 3, etc.

4) Create a view with a [Count]>0 filter to see only the duplicates.
Nick Ashcroft 6/10/2019 4:32:16 AM
hi Jorge,
thanks - Im familiar with this concept of joining tables to find duplicates.

However, its a real killer as far as performance is concerned so I would rather have a better solution by being able to filter summary views rather than join a table to itself.

Nick
Jorge Solá 6/10/2019 9:37:00 AM
I agree.
Nick Ashcroft 6/18/2019 9:08:28 AM
it would also be nice to allow sorting as well as filtering on the summary columns
Feedback
 
Back to Search Results