So this is a made up example, but I think it approximates my actual data/issue.
I have 3 tables of information, 2 of which are lookup tables, probably in a SnowFlake Pattern.
Table 1 - Recipe List - List of recipes with information on the recipes, serving size, calories
Table 2 - Ingredient List - List of ingredients for recipe's in Table 1, includes items/quantities.
Table 3 - Food Diary List - List of consumed recipes and the servings consumed.
Some of the questions I'm looking to be able to answer are:
How many total calories (full meals) did I consume when I ate carrots?
I'm looking for advice on how to structure my data to bring it in to Tableau. References and links are appreciated.
Sample data is in attached Excel file.
Become a Viz Whiz on the Forums!
Support the Community and master Tableau.
Retrieving data ...