Displaying data from multiple tables in Vega-lite

I’m trying to display data from two different tables in a chart using vega-lite.

I have two tables, one for “purchases” and one for “sales”.
each has a “week code” field to group the purchases and sales into weeks.

I can make a chart with the chart app or vega-lite for either table that visualizes the purchases and sales for each week.

But what I’d like to do is see that in one graph with the purchases one color and the sales another color.

I can’t find anywhere how to get vega-lite to reference a different table in Airtable.

I look forward to your ideas!


Something like this grouped bar chart would be amazing, but It’s just finding the way to reference the data in the other table.

This topic was solved and automatically closed 15 days after the last reply. New replies are no longer allowed.