Using Aggregation in Information Designer

To calculate average values:

1. In Information Designer, click New and select Column.

2. Click to select a value column in the Data Sources tree, for example a Sales column.

3. Click the topmost Add > button.

4. In the Expression field, type:
   
   AVG(%1)
    

   Comment: AVG is the average function. You can find more aggregate functions here.

5. Click next to Group By to show the controls determining over which column the aggregation will be made.

6. Click New to add an empty group by expression.

7. Click to select the column to group by in the Data Sources tree, for example a Type column.

8. Click Add > in the Group By Settings section.

9. Click Save.

   Response: The resulting column will consist of the average of the value column, for each value in the group by column. Using the example columns above it would be a column containing the average sales for each type of product.

Tip: Rather than hard coding the columns to aggregate over, you may consider marking the column as Drillable. The column will then be aggregated over any other columns retrieved in the same information link. More...

Note: When an information link is executed, aggregation is always applied before a column filter.