Hi folks, I’m just getting started with Metabase and it looks great so far. I have a database of cooking recipes with a schema like:
recipes --has many--> recipe_sections --has many--> ingredient_lines
The ingredient_lines table includes product (text) and quantity (numeric) columns. Can Metabase help me make a scatter plot of recipes where the axes are quantities of two products? I can join the three tables and filter on one product, but I can’t figure out how to add a second product and its quantities to a scatter.
I can change the schema, but the products aren’t always known in advance so I can’t just make a quantity column for every possible product. Thanks for any thoughts!