Allow aggregating of strings with CNT and DCNT in standard mode | Community
Skip to main content
Level 10
August 1, 2017
New

Allow aggregating of strings with CNT and DCNT in standard mode

  • August 1, 2017
  • 1 reply
  • 319 views

Right now you can only report on record counts and numbers for graphs and matrixes. You can do a CNT (Count) and DCNT (distinct count) on strings but these don't appear in graphs or the summary.

Please allow users to Count strings and include this in a report. A common use case is to see the numbers of projects that a particular worker has worked on in the past month whether or not they are complete. You could do this in an hour report but you'd need to use dcnt to get the proper number of projects.

1 reply

Level 9
September 25, 2020

Is this the same request as being able to use records counts in text mode expressions/formulas? For example, I want to divide the record count on a give filtered report by X to get a rate.