Calculate average in interface

[CliffRoss]

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.

[TheTimeSavingCo]

Try creating a 'Summary' table and link all your data records to a single record there:

Link to base

 '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!