Help

Reporting Functions Based on Counts/Sums

1271 1
cancel
Showing results for 
Search instead for 
Did you mean: 
Damon_Barnes
4 - Data Explorer
4 - Data Explorer

Currently I have a table of leads. I would want to count the number of new leads/total leads/etc based on weekly, monthly, quarterly, etc. Or ideally even a custom date range.

Any ideas on how to implement this within AirTable?

1 Reply 1
Ken_Moholt-Sieb
6 - Interface Innovator
6 - Interface Innovator

Try using the group feature to group the records by the dates in question. (You may need to create a column that uses a formula to classify the record). When Airtable groups records, it automatically gives you a count of the records in each group and a sum of any numeric fields.