Follow

Calculating Aggregations

Summary | Guide | Related Articles

Summary

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.

Guide

img 1

To use the Aggregate 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 will be positioned at the top of the table, as shown above. If Grouping is in effect, aggregate values will also appear at each grouping level in the table.
  5. Aggregating can be also be accomplished by clicking a column header in the table and then selecting the desired options from the context menu.

When finished, click the Gear icon to hide the configuration area.

Back to top

Related Articles

Analysis Module - Getting Started

Creating Analyses (Selecting Data)

Exporting Data

Back to top

Was this article helpful?
0 out of 0 found this helpful
Have more questions? Submit a request