Forum Discussion
Creating a custom column that calculates the previous row value by previous hour, date, & store
Hi ronrsnfld ! Thanks. I"ve tried your method but noticed that some of the numbers are off. It seems that as we get towards the later hours (for example 5 PM), the running difference (orders drop by hour) would be off. The screenshot below shows 74 orders were dropped at 5 PM. However, the total consumed at 4 PM was 117 and at 5 PM, it was 129. This would mean 5 PM would have had 12 orders dropped to that store. I checked my sort and it looks right. Any idea why this would be?
Maybe you sorted the data after instead of before the calculations were done. If that's not the problem, I'd need to see the actual data that is producing that result, not a screenshot.
Thanks! Sorry for the late reply. I"m going to try to post sample. I've tried multiples times and couldn't figure it out.
Anonymous wrote:Thanks! Sorry for the late reply. I"m going to try to post sample. I've tried multiples times and couldn't figure it out.
