Help

Calculate average records opened per week

1097 1
cancel
Showing results for 
Search instead for 
Did you mean: 
sjohnson
5 - Automation Enthusiast
5 - Automation Enthusiast

In the interface designer is there a way to calculate the average number of entries added per week?

We enter an intake date on the the data page for each new entry.

1 Reply 1
Vic_Airtable
Community Manager
Community Manager

Hi @sjohnson 

Are you looking for the average number of entries per week or the total number of entries per week? If wanting the total number per week, you could add a Chart element with your date field bucketed by week. If you're looking for the average, could you let me know how you are hoping to calculate that number? Would you want to count the total number of records per month and divide that by 4? If so, you could use a combination of Count fields and formula fields to obtain the average then use that field in a Number element in your interface.