Welcome to the Airtable Community! If you're new here, check out our Getting Started area to get the most out of your community experience.

Comparing Data Between Tables With Charts

Topic Labels: Extensions
599 1
Showing results for 
Search instead for 
Did you mean: 

I was wondering if there was a way to compare data with the chart app, between tables. I have a table that is '20, '21, and will begin a '22 one shortly. I would like to compare changes from year to year via charts. Is there a way to do this? or do I have to create 1 master table, give everything an identifier in a year field and then build the chart that way?

1 Reply 1

That’s correct. Cross-table comparisons can’t be done because the chart app only connects to an individual table.

Another option (just a variation on that master table idea) would be to sync your individual year tables to a single master table (look up multi-source syncing in the docs). If your individual tables have a date field, the year identifier could be handled automatically with a formula field that pulls out the year.