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.
Calculate average records opened per week
+4
+16Hi @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.
Login to the community
Enter your E-mail address. We'll send you an e-mail with instructions to reset your password.