Calculate the Average of Running Difference

mabryanjr — Thu, 15 Sep 2022 22:18:38 GMT

I have data that looks like this:

I can get the running difference using the fabs and above functions:

fabs(Column(1) - Above(TOTAL Column(1)))

What I am trying to accomplish is to have the data in the Avg MR column equal 13.67. (22+12+7)/3

My approach so far has been to use an aggr average on the Moving Range, but it only returns null values.

avg(total aggr(fabs(Column(1) - Above(TOTAL Column(1))), [Week Ending]))

Any help is much appreciated!

Re: Calculate the Average of Running Difference

Mario_De_Felipe — Mon, 03 Oct 2022 07:05:34 GMT

you could use RangeAvg :

1) Label your measure fabs(Column(1) - Above(TOTAL Column(1))) as "Dif"

2) Add new measure, name it "Average" and set expression RangeAvg([Dif],above([Average]))