This site uses different types of cookies, including analytics and functional cookies (its own and from other sites). To change your cookie settings or find out more, click here. If you continue browsing our website, you accept these cookies.
I wasn't positive whether you mean the sum of sales over the last 7 days from today, a rolling sum of the sales over the last 7 days for any given date in your data, or the sales that occurred on the day exactly 7 days ago (it sounds like this one?), so I built out an example of each of the three. Take a look, see if these either fix your issue or at least get you pointed in the right direction.