- Mark as New
- Bookmark
- Subscribe
- Subscribe to RSS Feed
- Permalink
- Report Inappropriate Content
‎Dec 18, 2024 08:55 AM
Hi, I'm currently trying to display my teams averages in an interface. In my table, I have a user field where records are assigned to a team member, a date completed field and a status field where the team marks "Complete" when finished.
In my interface, I would like to display the average count completed per day. I know this can be accomplished through lookup/rollup fields but I'm struggling to get it to work properly and would really appreciate some assistance.
- Mark as New
- Bookmark
- Subscribe
- Subscribe to RSS Feed
- Permalink
- Report Inappropriate Content
‎Dec 18, 2024 06:52 PM
Try creating a 'Summary' table and link all your data records to a single record there:
'Num days' has the following formula:
COUNTA(ARRAYUNIQUE(values))
And you can duplicate the base into your own workspace to view the field setups and experiment yourself!
