Optionally merge more keys, so we convert a multiple dimensional table into a two dimensional table which can be visualised by x y graph.
In this example dataset:
| Size | Year | Green | Blue |
|---|---|---|---|
| Small | 2010 | 10 | 15 |
| Small | 2015 | 12 | 17 |
| Medium | 2010 | 30 | 35 |
| Medium | 2015 | 32 | 37 |
| Large | 2010 | 60 | 70 |
| Large | 2015 | 62 | 72 |
If you merge the Year field with keys(Green, Blue), you would get a table that looks like below. In this way it can be shown as a x y graph:
| Size | 2010 Green | 2010 Blue | 2015 Green | 2015 Blue |
|---|---|---|---|---|
| Small | 10 | 15 | 12 | 17 |
| Medium | 30 | 35 | 32 | 37 |
| Large | 60 | 70 | 62 | 72 |
Another example dataset shows merge more fields:
| Size | Gender | Year | Qty |
|---|---|---|---|
| Small | Men | 2010 | 2 |
| Small | Men | 2015 | 3 |
| Small | Women | 2010 | 4 |
| Small | Women | 2015 | 3 |
| Medium | Men | 2010 | 4 |
| Medium | Men | 2015 | 5 |
| Medium | Women | 2010 | 7 |
| Medium | Women | 2015 | 6 |
| Large | Men | 2010 | 7 |
| Large | Men | 2015 | 3 |
| Large | Women | 2010 | 0 |
| Large | Women | 2015 | 9 |
If you merge the Year field with keys(Green, Blue), you would get a table that looks like below. In this way it can be shown as a chart:
| Size | Men 2010 Qty | Men 2015 Qty | Women 2010 Qty | Women 2015 Qty |
|---|---|---|---|---|
| Small | 2 | 3 | 4 | 3 |
| Medium | 4 | 5 | 7 | 6 |
| Large | 7 | 3 | 0 | 9 |