LinkedIn
Twitter
Hi - and thanks in advance......
My goal is to have an updating Sales Charts based on our sales reports.
Having used Looker my thought was to use Col Series (Stack) with an X axis of Date and a Y Axis of Pounds (ITEM SUBTOTAL), with the Stacks breaking down by Sales country.
My problem - I simply cannot get my date fields to work and unlike Looker cannot easily get the 3rd variable (i.e. ShipCountry) to stack.
My Core data looks like the table below (with more rows).
The Week Output is annoyingly a Text field.
Can you suggest how I can transform the data within Appsheet to make this work? I have the option of transforming the GSheet data before loading it to Appsheet but cannot alter the actual Data dump. I have tried various methods but they feel clunky and I am sure I am missing a basic element to get this working better.
| Ship Country | Week | Year | Item Subtotal |
| SE | Week 12 | 2024 | ยฃ 149.73 |
| SE | Week 14 | 2024 | ยฃ 149.73 |
| SE | Week 18 | 2024 | ยฃ 351.30 |
| PL | Week 8 | 2024 | ยฃ 68.29 |
| PL | Week 13 | 2024 | ยฃ 139.85 |
| NL | Week 4 | 2024 | ยฃ - |
| NL | Week 6 | 2024 | ยฃ 12.58 |
| NL | Week 7 | 2024 | ยฃ 12.58 |
| NL | Week 8 | 2024 | ยฃ 12.55 |
| NL | Week 10 | 2024 | ยฃ 12.57 |
| NL | Week 13 | 2024 | ยฃ 25.46 |
| NL | Week 14 | 2024 | ยฃ 12.75 |
| IT | Week 2 | 2024 | ยฃ 33.16 |
| IT | Week 4 | 2024 | ยฃ 66.92 |
| IT | Week 5 | 2024 | ยฃ 67.16 |
| IT | Week 6 | 2024 | ยฃ 49.81 |
| IT | Week 7 | 2024 | ยฃ 231.11 |
| IT | Week 8 | 2024 | ยฃ 82.44 |
| IT | Week 9 | 2024 | ยฃ 183.80 |
| IT | Week 10 | 2024 | ยฃ 98.94 |
| IT | Week 11 | 2024 | ยฃ 66.29 |
| IT | Week 12 | 2024 | ยฃ 97.28 |
| IT | Week 13 | 2024 | ยฃ 49.99 |
| IT | Week 14 | 2024 | ยฃ 83.34 |
| IT | Week 16 | 2024 | ยฃ 134.18 |
| IT | Week 17 | 2024 | ยฃ 182.25 |
| IT | Week 18 | 2024 | ยฃ 83.88 |
| GB | Week 1 | 2024 | ยฃ 7,551.56 |
| GB | Week 2 | 2024 | ยฃ 7,665.97 |
| GB | Week 3 | 2024 | ยฃ 8,020.28 |
| GB | Week 4 | 2024 | ยฃ 8,355.20 |
| GB | Week 5 | 2024 | ยฃ 8,157.30 |
| GB | Week 6 | 2024 | ยฃ 8,261.95 |
Here is an image of my Table Data Configuration and Chart
