Comparing daily sales per station by offsetting data by 7 day in order to compare Monday with Monday prior week

Question & Answer
1

I have daily sales for 500 gasstations and would like to compare sales day by day offsetting it by 7 days in order to compare monday with monday prior week

2

Have you tried create a calculated field with lag() function?