Aggr

[Vittore8]

Please show simple examples for using aggr()

[Lisa_P]

The aggr function will aggregate by a dimension. See the picture below:

You see a bar chart using year as a dimension, this is automatically aggregating the Number of orders by year.  Then you can see it in a table form.  The third object is a filter pane, where you are forcing the Number of orders to be broken down by year. This is helpful if you want to add an average line to the bar chart, so that you can get the average by year.