Weekly financial report: for every day we need the sum of revenue over the last seven days inclusive (this day plus the previous six). This view is often called «trailing 7-day». For every day compute that rolling sum. For the first six days the window is physically smaller than seven — that's fine, the result is still valid (just the sum of whatever is there). Sort by day.