Get Total Sum of Data for a specific date range (week)

Hi All, 

Reading through the posts - I'm starting to see that rolling dates are not an feature yet available in Knack. 

Does anyone have a work around for grabbing total sum over a specific period of time (week)?

In our example, our customer needs to know how many partss were made in Week 1, Week 2, Week 3, and Week 4 of each month? 

We have the individual records of parts made per day - but trying to consolidate that into a table that shows the total contribution of the entire week has been difficult.