Rolling Average Issue

[#1]

Hi Everyone,

Need advise with Rolling Monthly Average. Please see below how I tried but failed.

[sunny_talwar]

As far as I know, reference lines are straight lines and cannot move up or down. Why don't you use a combo chart and add another expression (RangeAvg(Above(Sum([Total BBLs]), 0, 12))/1000000) for your reference line.

[#3]

The problem is the Dimension has Product(which is broken down into several sub-products). See below

I don't want the Average for each Sub-products, but the moving average of the main products, and the same time displaying the sub-products in each bar.

[sunny_talwar]

Maybe use TOTAL in your expression:

RangeAvg(Above(Sum(TOTAL <Sub-Poducts> [Total BBLs]), 0, 12))/1000000

[#5]

Hmm, doesn't work.

[sunny_talwar]

Not sure if this will work or not, but can you try this as well?

RangeAvg(Above(Sum(TOTAL <Product> [Total BBLs]), 0, 12))/1000000

[#7]

See below, I am trying to put a Rolling Average for the below chart