Your achievements

Level 1

0% to

Level 2

Tip /
Sign in

Sign in to Community

to gain points, level up, and earn exciting badges like the new
Bedrock Mission!

Learn more

View all

Sign in to view all badges

Allow aggregating of strings with CNT and DCNT in standard mode

Avatar

Level 10

01-08-2017

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 Comment

Avatar

Level 9

25-09-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.