Performing Analysis over a long period of time can result in performance issues or timeouts due to the complex calculations and large amounts of data.
This KB describes a strategy for long-term analysis.
Using the Historical Cache Key and Cache Expiration Analysis Settings Setting, we can cache historical calculations and recall them at a later time by accessing the cached value.
You must have a cache key per calculation and no changes can be made to the filter properties after it is saved or recalculation will occur.
See Analysis Data Points and Settings#SettingValues for information on Historical Cache Key and Cache Expiration
Viewing the output, we can see the first calculation was 24 seconds. Subsequent executions using the same keys and settings are performed sub-second.
Using this example, you would then populate tables or charts with historical data while calculating current data.
Dataset manipulation would be necessary to achieve a successful historical report.