Formatting table for Likert ratings chart

[Rory_Sacks]

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?

[Justin_Barrett]

Rory_Sacks:

or do I have to create 1 master table, give everything an identifier in a year field and then build the chart that way?

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.