Forum Discussion
warrencowan
Kudo Collector
Kudo CollectorNeed help creating date delta columns
I have a value in a column, eg (visits), and in another column I have the (date). I also have 3 rows for each date, because I have 3 different stores (StoreID) with a vlaue for visits I want to b...
you may also take a look at lookupvalue() function ...
warrencowanKudo Collector
Kudo CollectorThis is my data structure btw before anyone asks :smileywink:
| Date | Visits | Store | Daily Delta |
| 01/01/2015 | 3 | London | ? |
| 01/01/2015 | 2 | London | ? |
| 01/01/2015 | 3 | London | ? |
| 02/01/2015 | 5 | Leeds | ? |
| 02/01/2015 | 6 | Leeds | ? |
| 02/01/2015 | 1 | Leeds | ? |
| 03/01/2015 | 3 | Manchester | ? |
| 03/01/2015 | 4 | Manchester | ? |
| 03/01/2015 | 1 | Manchester | ? |
Greg_Deckler
Community Champion
Community ChampionDid you really mean to have all the London rows be the same date, all the Leeds rows be the same date, etc.? Or did you mean for each date to have a London row, Leeds row and Manchester row?
It would seem that this would be a good case to user EARLIER but only if your data is sorted on import by Store and Date and even then it is going to mess up when transitioning between stores, unless you imported each store as a separate table.