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

Need an aggregation of an aggregation? Use Visual Data Builder to pre-aggregate your data

Reply
SAS Employee
Posts: 10

Need an aggregation of an aggregation? Use Visual Data Builder to pre-aggregate your data

Report designers often discover after aggregating data by groups in the Visual Analytics Designer that it would also be nice to see additional aggregations of the data, for example, a maximum or minimum of that sum across groups. This means creating an ‘aggregation of an aggregation.’  If you plan your report objectives in advance of loading your data, you can do this by creating an aggregation initially in the Visual Data Builder, rather than the Designer.  And in many cases, it’s possible to get the desired report results by simply loading a small additional table to memory.

Read the rest of my blog here:

http://blogs.sas.com/content/sgf/2016/06/21/need-an-aggregation-of-an-aggregation-use-visual-data-bu...

Ask a Question
Discussion stats
  • 0 replies
  • 335 views
  • 3 likes
  • 1 in conversation