Hi @clarencey! Thanks for reaching out and continuing to share your feedback.
I’m happy to report that we are actively working on supporting a custom rolling date range, (i.e. last x period, next x period), which would provide a future-looking view. The initial place that this will be supported is within the custom report builder, specifically with the new date range comparisons functionality, which is currently in a public beta. Alongside the update in the custom report builder, we are working with the filters team to have this added as a standard option overall.
I anticipate that the custom report builder will support a custom rolling date range for our “Compare by” beta feature this quarter, and there are plans for implementation in standard filtering later this year. For now, I’d recommend using the “days from now” option when doing future-looking filters within Lists, which can then be applied as a filter to any custom report.
I will update this thread as this work progresses, and thanks again for all of your valuable feedback!