Skip to main content

Reporting Functions Based on Counts/Sums

  • May 1, 2017
  • 1 reply
  • 24 views

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?

This topic has been closed for replies.

1 reply

Forum|alt.badge.img+2
  • Participating Frequently
  • May 2, 2017

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.