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 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.