Hey Geoff,
This sounds like you would want to use datasets so you can have multiple datasets in a single report. It's a cool little feature that sometimes isn't obvious to see
I won't do your full report, but when you save a report, you can then add a dataset onto it. You can either have it as a drilldown(where you can show another report when someone clicks into data on your primary report) or in this case, have multiple sets at once, in a single report view.
The relative option in condition builder is useful as you can select specific date fields on a table and appropriate time to them, like 2 days ago or 3 days from now etc.
Community forum not working fully since the upgrade, but if you search our Product Documentation site there is good information on datasets in reports.
