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.
Displaying team average in interface
+3
+31Try 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!
Login to the community
Enter your E-mail address. We'll send you an e-mail with instructions to reset your password.