I have data that looks like this:
| date | store | purchases | returns |
| 2014-12-29 | Store A | 6000 | 800 |
| 2015-01-05 | Store A | 26000 | 4000 |
| 2014-12-29 | Store B | 1300 | 600 |
| 2015-01-05 | Store B | 4900 | 2000 |
How do I create a timeseries chart which would create 4 lines? The X axis would be date, Y axis count, Line 1 = Store A Purchases, Line 2 = Store B Purchases, Line 3 = Store A Returns, Line 4 = Store B Returns.
Right now, all I am able to successfully get is 2 lines with Store A Purchases and Store B Purchases.
Thanks
