Possible to make a scatter plot with two filters on the same table?

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!

Hi @thebenedict
If I’m understand you correctly, it looks like you’re looking for this feature:
https://github.com/metabase/metabase/issues/11254 - upvote by clicking :+1: on the first post

Hi Flamber,
Thank you for the reply. That issue looks useful – I added an upvote – but it also seems like my data model is hard to visualize with metabase. The blog post https://www.metabase.com/blog/Joins/ is related. Views help, but I don’t think they apply in the general case where ingredients aren’t known in advance.

@thebenedict Since version 0.33, it’s been possible to join tables with the interface (with some limitations), so maybe you’re able to get to your end-result with the Notebook editor?
https://www.metabase.com/docs/latest/users-guide/custom-questions.html
It’s not a substitution for advanced views, but now regular users can get a lot further without having to touch SQL.