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

Create slowly changing aggregated measures.

Reply
Occasional Contributor
Posts: 7

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?

Post a Question
Discussion Stats
  • 0 replies
  • 188 views
  • 0 likes
  • 1 in conversation