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?
Hi
use pre_filter option in parameter with min/max summary function.
regards,
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.
Thanks,
Ryane Brady
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
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?