Forum Discussion

ChristineWhite's avatar
ChristineWhite
Qrew Assistant Captain
7 years ago

Count Unique records

I am trying to count the number of unique projects worked per month using timesheets.  A project can appear multiple times per week as well as per user.  Does QB have count if Unique?  (I created a "Month" table (Each month has many timesheets and wanted to find a way to count the number of unique projects per month)  Thanks!
Ask about Quickbase functionality
  • LauraThacker's avatar
    LauraThacker
    Qrew Captain
    7 years ago
    You should be able to achieve this by a summary report grouped by the unique-project value; and then filtered on your date ranges (which you can set each time you run the report).