Help

Save the date! Join us on October 16 for our Product Ops launch event. Register here.

Introducing Pivot Tables in Interfaces

cancel
Showing results for 
Search instead for 
Did you mean: 
Rosalind_Lutsky
Community Manager
Community Manager

Hi there! I’m Rosalind – a product marketing manager at Airtable focused on helping teams build powerful, custom applications that make work more efficient. I’m eager to share that we have just launched support for pivot tables in interfaces!

Starting today, all users on a Teams plan or higher will have access to pivot tables directly in interfaces.

What is a pivot table?

A pivot table is a powerful data analysis tool for succinctly summarizing and analyzing large datasets. The format of a pivot table lets you rearrange and aggregate data dynamically, making it easier to identify patterns, trends, and insights. 

Historically, the only way to use pivot tables in Airtable was via the Pivot table extension. With the launch of this new feature, you can easily add pivot tables directly to an interface page without relying on an extension.

How can you use a pivot table?

Aggregate and summarize your data. Pivot tables allow for the aggregation and summarization of large datasets into manageable blocks of information. You can use a pivot table to quickly condense vast amounts of data into meaningful summaries, such as totals, averages, counts, and percentages.

Explore your data from multiple perspectives. Pivot tables offer dynamic analysis capabilities, making it easy to slice and dice your data in different ways. With the ability to rearrange specific fields, you can quickly switch between different dimensions and hierarchies to uncover patterns, trends, and outliers.

Customize how your data is displayed. Pivot tables provide a high degree of customization and flexibility, allowing you to tailor your analysis to fit your team’s specific needs and preferences. From adjusting layouts and formats to applying filters and sorting, pivot tables give you full control over how your data is presented and analyzed – making it easier to derive actionable insights.

Where can you access pivot tables in Airtable?

Initially, pivot tables will only be supported in dashboard layouts. To add a pivot table to a dashboard, open the “+ Add to group” menu and select “Pivot table”

PT_Example_2.png

 

For more information on selecting row and column groupings, splitting multiple values, determining what is displayed in your table, and accessing underlying records from a pivot table, you can read through the support article on the dashboard layout here.

We’re excited to see what you can do with pivot tables! As we continue to add new features to interfaces, we’ll be sure to keep you updated here and on our What’s New page.

24 Comments
kschnaenberg
6 - Interface Innovator
6 - Interface Innovator

So useful!  Is there a training session planned for this function add?  

Matthew_Carrano
6 - Interface Innovator
6 - Interface Innovator

You can't group by multiple fields though.

Reagan_Daughtry
5 - Automation Enthusiast
5 - Automation Enthusiast

WooHooo!! You guys are killing it! This is awesome! 🥳🥳

Rosalind_Lutsky
Community Manager
Community Manager

@kschnaenberg We don't have a dedicated training session planned for pivot tables but I can absolutely bring that back to the team! In the meantime, I recommend checking out the support article here to get started with pivot tables. We also plan to host dedicated webinars on working with interfaces in the coming weeks which may be useful as well.

Rosalind_Lutsky
Community Manager
Community Manager

@Matthew_Carrano at the moment, grouping is limited to a single field. That said, we hope to expand our pivot table capability in the coming months.

Kamille_Parks
16 - Uranus
16 - Uranus

Pivot Tables need to be placeable on Detail Pages and ideally "legacy" page types (like blank and record review) to be most useable.

Its a good start, but using 2-3 fields for columns/rows would be great.

Joseph_Roza
8 - Airtable Astronomer
8 - Airtable Astronomer

Fantastic addition to interfaces. My question is: is this view available to free users? If I recall, this used to only be available to people on paid plans.

bsimpson_1015
4 - Data Explorer
4 - Data Explorer

This is super awesome pivot tables are starting to be integrated into Airtable functionality! Is it planned to be able to export the pivot tables to .csv files or added to the base views? 

Those additions would be game changers for workflows. 

sjors
4 - Data Explorer
4 - Data Explorer

Would be very very useful if we can group multiple fields in the current Pivot table. We hope it's on the backlog ;). Great feature! Cheers, Sjors

Kelly_OShaughne
Airtable Employee
Airtable Employee

@Joseph_Roza this is only available for paid plans similar to the pivot table extension