Reporting Functions Based on Counts/Sums


#1

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?


#2

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.