Hi, I want to add a rolling average to a graph as a line. However it doesn't seem to be possible so I would be grateful for any help. I have a graph with a category x axis of the month start date in the field settledDt, and I want to sum the last 3 months into a trend line. Conceptually something like this:
, Sum(Fields.settledDt >= AddNonths(-2, Max(Fields.settledDt)) ? Fields.initial_total : Null))
What I'm trying to say here is if the month is within the last 3 in the RunningValue, then include initial_total in the sum, but of course this expression is invalid due to the nested aggregate. My reports are all in trdx format with no code, so a no code solution is what I'd like.