Scatter Plot with Moving Average
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?