topic Re: missing values using AggregateCells operator in SAS VA 8.3? in SAS Visual Analytics

missing values using AggregateCells operator in SAS VA 8.3?

Frank_Boekamp — Tue, 19 Feb 2019 10:10:50 GMT

I'm using the (new) AggregateCells operator for calculating a moving average in SAS VA 8.3 like below

AggregateCells(_Average_, My measure, default,CellIndex(current, -4), CellIndex(current, 0))

Problem is that the first 4 periods return values instead of missing values. So for example for period 1 the moving average is calculated is an average of just the value of period 1. For period 2 the moving average is calculated is an average of just the values of period 1 and period 2. etc. This is not correct behavior in my opinion: I would not expect to see values for the first 4 periods when using this operator.

What can I do to show correct results?

Re: missing values using AggregateCells operator in SAS VA 8.3?

Sam_SAS — Tue, 19 Feb 2019 13:50:33 GMT

Hi Frank,

Generally speaking in VA, missing values are ignored when aggregating values. So the average of (., 1, 3) is 2 and not missing.

I believe this is the logic behind returning values for the first four periods in your aggregated item.

I don't think there is a workaround, unless you want to pre-aggregate the moving average in your data prep.

I'll pass on your feedback to the developer.

Thanks,

Sam

Re: missing values using AggregateCells operator in SAS VA 8.3?

Frank_Boekamp — Tue, 19 Feb 2019 15:47:04 GMT

Thanks Sam