Goal: report variable creation which returns the sales for the last completed month
Notes:
-Report is scheduled to run the 10th of every month with data reported on from January 1 of the year through the 9th of the month
-Report variable needed is to isolate sales from the previous full month
Example: report ran for 1/1/2015-12/7/2015 and the report variable would need to return dates for 11/1/2015-111/30/2015.
The goal is to have this report continue to be automated, as I do not want to access the report every month to adjust a static report variable.
Build relative dates and use these to restrict your queries. Schedule the report to run on the 10th. Similarly, you can add these date objects to your result objects and then use them in the report variables to present your date range.