Calculate windowAvg outside of date filter range?

Vinay · April 13, 2022, 5:25pm

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?

Naveed · April 14, 2022, 9:42am

Hi

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

regards,
Naveed Ali

rbrady · April 14, 2022, 4:55pm

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.

Thanks,
Ryane Brady

Peter · September 26, 2022, 8:53pm

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.

jbarokas · February 7, 2025, 6:43pm

Hi Peter, avgOver does not allow for a trailing window average though. Meaning, each day you want the N number of days prior to “smooth” out a measurement. avgOver uses another categorical value to do the grouping. Were you able to get this working using a trailing window PRE_FILTER?