After much scouring of the web, I am unable to find a solution to the following: I want to create a query for the sum of purchases for the last 30 days grouped by item.
This will be a rolling 30 days, so will likely involve the CURRENT_DATE function.
The fields are:
- Items (the names of the products) - group by this field
- Charge (the cost of the item) - sum this field
- Purchase Date (date of purchase) - I’m not wanting to display this in the results, but need to set the criterion for last 30 days
It’s the criterion for the Purchase Date that I’m struggling with. Thanks in advance!