AFAIK the best way to do this is by leveraging the LBAPI (Lookback API), which can give you the state of an object at a point in time (you can query it as well).
GitHub - ericlifka/Rally-Lookback-Toolkit: Toolkit for interacting with the Rally Lookback API
The above site has some good examples.
Good info here: https://rally1.rallydev.com/analytics/doc/#/manual
Hope this helps. While there may be others that may have written a custom app or program, not sure there's anything out there that applies to your situation. If you or someone on your team can code they can easily take advantage of the LBAPI features to get you the info you need, then use AT on Windows or cron on unix systems to run that program and generate whatever reports the program will output.