So, I can't figure out how to do moving average as custom calculation in Databricks dashboard. I'm applying many different filters and the denominator of the metric has to change dynamically based on the chosen filters. So, in this case using `Custom Calculation` worked fine and example calculation of the metric is shown below. But now I'm facing a problem where I need to take a moving average of this dynamically calculated metric. I can't do the calculation in the query because the calculation wouldn't be correct when filtered. I also can't use parameters as filters because some business use cases limit the parameters. I'd appreciate if you have any suggestions.
