06-27-2016 02:52 PM
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: