Calculating Average Submissions Per Day Formula

Answers
-
I would also like to find a formula to use to count submissions per day and return an average.
-
@Sara Kouba would this work for you? My example uses Absence Date, you would replace that with Submission Date and have your average. I hope this helps!
=COUNT([Absence Date]:[Absence Date]) / COUNT(DISTINCT([Absence Date]:[Absence Date]))
In my example sheet here I have 4944 entries/submissions, on 35 different days (used DISTINCT in the formula so I can count the unique days to divide the submissions by). 4944 (first half of formula) divided by 35 (second half of formula) comes out to 141.25 submissions per day. I don't usually do things like this in the same sheet where the data is, but wanted to put this in an easy to screenshot view :)
-
I will try this! Thank you! My ultimate goal is to get this information onto a dashboard. I would love to do so with a way to have drop downs on the dashboard to specify a range of time to calculate the average submissions between the two dates. I have to do this to get information for 26 separate, but identical, sheets.
Help Article Resources
Categories
- All Categories
- 14 Welcome to the Community
- Customer Resources
- 65.9K Get Help
- 429 Global Discussions
- 147 Industry Talk
- 487 Announcements
- 5.2K Ideas & Feature Requests
- 86 Brandfolder
- 151 Just for fun
- 74 Community Job Board
- 497 Show & Tell
- 33 Member Spotlight
- 2 SmartStories
- 305 Events
- 36 Webinars
- 7.3K Forum Archives
Check out the Formula Handbook template!