Forum Discussion
link columns
Hello everyone,
I have an issue. I explain myself with an example.
Ex: I sell burgers for the same price but some client do not want pickles for example.
Let's say that I sold 100 burgers for january : that is 1 column.
And I have also 1 column for each ingredients that I use (pickels, bun, cheese, steak, etc.).
How do I link these ingredients to my burgers sale knowing that I want my 100 burgers to appear but also I want to show that I only used 90 pickles, 100 steaks, 80 cheese and 100 buns on the same graph.
Thank you !
Is that how your current data is stored? What can you tell me about the related table? What does the desired result look like?
13 Replies
Hi Thomas897
There are different ways to go about your topic. For example you could have a certain table structure, which allows you to count how many ingredients you've used for each burger. The table structure could look something like this:
Burger Bun pickle Steak Cheese 1 1 0 1 1 2 1 1 1 0 3 1 1 1 1 4 1 0 1 0 5 1 1 1 1 Here I've used binary columns to determine what ingredients where used for each burger.
Does this make sense? I'll gladly elaborate.
Best,
Martin
Hi Anonymous,
I would like to show that when I click on my supplier (ex: Kraft for my cheese), how much of their product is used on my 100 burgers.
I have all these informations but I cannot find a way to connect it...
Best,
Thomas
