I would like to create a rolling average calculation to use in a line chart. The functions runningAverage
and windowAverage
do not fit my use case.
I want to create a calculation that averages {field} for rows with {OM Date} <= {date} and {OM Date} >= {date}-30days.
In my dataset, not all days appear in {OM Date}, which is why runningAverage
and windowAverage
do not fit my use case.
The solution here is becoming difficult for a larger dataset and increasingly difficult to add other filters.
When adding an additional filter, following this solution, I would need another cross join. Instead of adding another cross join, I tried to pass a multiselect parameter to a calculation, but there are some bugs with this new feature.
I want to revisit this because expanding the use case of this solution is difficult.