Rolling AVG when there is missing data

[Max]

Have you looked at this?

Rolling Average calc for use in line chart

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 runningAverageandwindowAverage` do not fit my use case. The closest I have gotten to a solution is creating a date parameter and plugging it into a calculation and x-axi…