Yeah this can be done.
Build your Compliance Report. Then add the Date Range Filter. This will allow you to choose: Past Week as a filter. As long as your ETL completed the night before you should get the compliance results from the day before and the past weeks results.