I've discovered a weakness in Rolling Date ranges when they are supposed to be relative to a rolling Panel Date Period.
If you have a Fixed Start Date but Rolling end date for the Panel, or if a project is deisgned to allow users to change the panel date range, you cannot create a Rolling Date range that will stay relative to that, because it only considers the Start Date and not the End Date.
For example, I wanted to make a Year-on-year comparison period that was relative to the panel date, so users can easily see the metrics for the same period in the previous year.
The Start date for the period is easy - simply Current Day (based on panel date) - 365, however you cannot set the correct end date as you cannot predict the length of the Panel Date Range they are going to use (or if the panel date range has a fixed start but rolling end, so it is continually growing).
The logical way to do this would be to include relativity to the Panel End Date as well as the Panel Start Date. eg.
Start Date = Current (Panel Start) Date - 365
End Date = Current (Panel End) Date - 365
Any anybody found a way around this other than having to create custom date ranges for each project?
