Unlock a world of possibilities! Login now and discover the exclusive benefits awaiting you.
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!!
Try this may be:
RangeAvg(Above(Sum([Total BBLs])/1000000, 0, 12))
The chart splits into different products(Dubai, Oman etc) when I added that Expression. So does not work
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))
Got below chart, chart still splitting the products.
It is possible that I need to change my the other Expression so that my bar charts will not split? see below
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.