Unlock a world of possibilities! Login now and discover the exclusive benefits awaiting you.
Hi Everyone,
Need advise with Rolling Monthly Average. Please see below how I tried but failed.
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.
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.
Maybe use TOTAL in your expression:
RangeAvg(Above(Sum(TOTAL <Sub-Poducts> [Total BBLs]), 0, 12))/1000000
Hmm, doesn't work.
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
See below, I am trying to put a Rolling Average for the below chart