Exploring, predicting and reporting with SAS Visual Analytics and SAS Visual Statistics

Create slowly changing aggregated measures.

Occasional Contributor
Posts: 9

Create slowly changing aggregated measures.

I have a fact table which contains historical sales data.

I create monthly average of sales by aggregated measure.

I also want to create a quarter average or percentile on the same time series plot with the same dimension .

For example, I calculate a monthly average of Nov 2013, I also want to have a 95 percentile of the data between Sep~Nov 2013 on the same plot.

How to create the aggregated measure and time series plot?

Ask a Question
Discussion stats
  • 0 replies
  • 1 in conversation