Hi there,
I have two tables that share the same universe of data (eg. all fruits) but are otherwise unrelated in the model.
One of the tables associates a person's preferred fruit:
| PersonA | Apple |
| PersonA | Orange |
| PersonA | Pineapple |
| PersonB | Apple |
| PersonB | Pear |
And another shows which fruits show up in a specific recipe:
| Strawbery Shortcake | Strawberry |
| Caramelized Apples | Apple |
| Fruit Salad | Apple |
| Fruit Salad | Melon |
| Fruit Salad | Orange |
I want to show in a bar chart, given a specific person, how often their favourite fruit shows up in a recipe. For example, I want to be able to filter for PersonA, and have this chart show [Apple, Orange, Pineapple] in the X-axis, and [2,1,0] show up in the Y-axis respectively.
I'm having trouble figuring out how to do this. Open to any suggestions!
Thank you!
