'Quicksight: Calculate windowAvg outside of date filter range?

Is it possible to calculate a window average using dates outside of a date filter range? Currently, windowAvg does not look past the filtered range though there is data. Is there any hack I can do to make that happen?



Sources

This article follows the attribution requirements of Stack Overflow and is licensed under CC BY-SA 3.0.

Source: Stack Overflow

Solution Source