12 Month Rolling Average Query

[#1]

Hello Everyone,

I am trying to do a 12 month rolling average with the chart below.

See below Expression I used to generate above chart. How do I do a 12 months rolling AVG for above chart please?

Thanks tons in advance!!

[sunny_talwar]

Try this may be:

RangeAvg(Above(Sum([Total BBLs])/1000000, 0, 12))

[#3]

The chart splits into different products(Dubai, Oman etc) when I added that Expression. So does not work

[sunny_talwar]

If you want it to be 12 Month Average of all products together, you might need this:

=RangeAvg(Above(Aggr(Sum([Total BBLs])/1000000, Trade_Month_Year), 0, 12))

[#5]

Got below chart, chart still splitting the products.

[#6]

It is possible that I need to change my the other Expression so that my bar charts will not split? see below

[jonathandienst]

I don't think you can combine a stacked bar (stacked via dimension) with a line on a second expression. The line forces the second dimension onto the axis.