ACE Analytics Calculating Aggregations

The Aggregate feature in the Table configuration area, which can be displayed by clicking the Gear icon or by clicking any table column header, lets you calculate totals, averages, and other aggregations:

Here's how to use this feature:

1. Select the Data Column to be aggregated from the column list.
2. Select the Aggregate Function. Options include: Sum, Average, Standard Deviation, Count, Distinct Count, Minimum, and Maximum. Click Add to aggregate the data and refresh the table.
3. As aggregates are created, they're added to the Aggregates list. Use the adjacent Replace and Remove buttons to manage the list.
4. Aggregate results appear in an extra table row that can be positioned at the top or bottom of the table, as shown above. If Grouping is in effect, aggregate values will also appear at each grouping level in the table.

Generally, columns with Null values are excluded from aggregations. However, your application may be configured to include them; check with the developer of your application for details.

Click the Gear icon to hide the configuration area.