Displaying data from multiple tables in Vega-lite

[Jonathan_Cardoz]

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!

[Jonathan_Cardoz]

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

Vega-Lite

Bar

Vega-Lite - a high-level grammar for statistical graphics. Vega-Lite provides a higher-level grammar for visual analysis, comparable to ggplot or Tableau, that generates complete Vega specifications. Vega-Lite specifications consist of simple...