Reporting in Airtable Articles
  • 07 Jul 2022
  • 1 Minute to read
  • Dark
    Light
  • PDF

Reporting in Airtable Articles

  • Dark
    Light
  • PDF

Article Summary

You can use the grouped records feature to create reports in Airtable.

For example: suppose you have a sales pipeline in Airtable.

115017111548ScreenShot2017-07-11at11421PM.png

If you used the group records feature, you can group by which sales opportunities closed successfully, by lead type, or any number of other criteria (depending on what your table looks like, of course).

115017020407ScreenShot2017-07-11at11520PM.png

Notice that when the records are grouped, the summary bar shows separate summaries for each of the groups and sub-groups. You can pick from a variety of different possible summary functions (e.g. median, range, standard deviation) depending on the type of field.

In this example, the summary bar is showing us the total number of successfully closed deals, the average amount of those closed deals in dollars, the earliest date of last contact for closed deals, and the median number of licenses sold in each successfully closed deal.

115017111808ScreenShot2017-07-11at11944PM.png

These summary functions will show for all of the different groups of records, so you can compare and contrast between groups. Looks like we failed to close some pretty big deals...

115017020587ScreenShot2017-07-11at11704PM.png

You can drill down even further by adding another grouping (and another, and another...).

115017113388ScreenShot2017-07-11at13939PM.png

115017024387report5.gif

For many reports, grouping on a date range is particularly useful—for example, if you want to group records by the month, year, or quarter in which they occurred. If you're interested in learning how, this article on grouping on a date range can give you some pointers.


Was this article helpful?