Count Unique records

  • 0
  • 2
  • Question
  • Updated 1 year ago
  • Answered
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!
Photo of Christine

Christine

  • 362 Points 250 badge 2x thumb

Posted 1 year ago

  • 0
  • 2
Photo of QuickBasePros (Laura Thacker)

QuickBasePros (Laura Thacker), Champion

  • 5,590 Points 5k badge 2x thumb
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).