Help

The Community will be temporarily unavailable starting on Friday February 28. We’ll be back as soon as we can! To learn more, check out our Announcements blog post.

Comparing Data Between Tables With Charts

Topic Labels: Extensions
2002 1
cancel
Showing results for 
Search instead for 
Did you mean: 
Rory_Sacks
5 - Automation Enthusiast
5 - Automation Enthusiast

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.