I have a chart using Month as the dimension. I want to write an expression that calculates the average of a calculation over the previous six months. Does anyone have an example of something similar (even if just slightly similar)? So, the expression must use data that is outside of the dimension value for that row in the chart.
I know it must be one of the chart aggregation functions but I'm getting tangled in my shorts trying to think through this one. Thanks for any help.