Scatter Plot with Moving Average

Hi All,

I wanted to create a Scatter Plot with a moving average line. By Creating the moving average I wanted to show if there is upward and downward trend in the completion of tasks.

Attached is the dxp and data.

 I created the scatter plot with opened date on X axis and Duration on Y axis. 

I tried creating a moving average column with the below formula but it is giving me error.


THEN Avg([Value]) OVER (LastPeriods(2,[Axis.Rows]))

THEN If(Count() OVER (LastPeriods(2,[Axis.Rows]))=2,[Value],null)

Can Anyone help me how to solve this?

Thank you,


Binary Data testing_data.dxp231.22 KB

(1) Answer