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?


use pre_filter option in parameter with min/max summary function.

Naveed Ali

Hi Naveed,

I am trying to do this same thing and I’m struggling with it. Would you be able to post an example of what you mean? I’m having a hard time putting it together.

Ryane Brady

Hi @Vinay @rbrady ,

You can accomplish this by creating a calculated field that uses a window function like avgOver() and using the PRE_FILTER calculation level as @Naveed suggested.

1 Like