Count number of times specific User is used in a table

  • 0
  • 1
  • Question
  • Updated 3 years ago
  • Answered

We use User fields in several tables to track productivity (When an employee completes a task, their User is added to the record). Is there a way to summarize/count the number of times each User was chosen?

We do have a table with all of the Users attached to individual employees, but do not utilize that relationship within each table. I believe I could set it up through that table, but that would require us to build 15-20 relationships instead of just using a User field within each table.   

Photo of John

John

  • 60 Points

Posted 3 years ago

  • 0
  • 1
Photo of Jack

Jack, Champion

  • 50 Points
John,

Have you tried building a summary report in the tasks table displaying users on it?

That should achieve the above.

Regards

Jack
Photo of Ann

Ann

  • 20 Points
You may be able to do that through the calculated column in the report.