Average Calculation

[Vinothishere]

Hi All,

    I have daily sales forecast data till 2017, I have to calculate the average of next three weeks sales in chart expression.For every week  I have to display the average of next 3 weeks value.

     How to calculate?

Thanks in advance

Regards,

VR

[MK_QSL]

Calculating rolling n-period totals, averages or other aggregations

[Vinothishere]

I have tried this expression sum( aggr( rangeavg(below( sum(sales),0,3) ),Week)) but it is not returning correct result

[MK_QSL]

You have to create as of table !

Read the full blog and try to implement the same !

[Vinothishere]

Is there any way to calculate it in the chart expression?

[MK_QSL]

You can but on selecting certain field, will alter your result.

[Vinothishere]

I have created asof table but its not returning expected result.