Aggregate Values and Totals
Aggregation operators are available from the Column Header Properties panel, which is accessed by clicking the icon to the right of the field name in the Table Columns section. Aggregation operators enable users to total their reports by applying average, minimum, maximum, or sum to selected columns. Reporting 2.0 delivers aggregations for the entire data set and outputs the result in the last line of the report.
Aggregate values display for each segment of a summarized report. In addition, a grand summary appears as the last row in a summarized report.
Note: Group aggregation is available by summarizing the report. See Summarize Report.
The type of operator that is available for a field depends on the field type. All fields can be aggregated by count and count unique, but only numeric fields can be aggregated by sum, average, minimum, and maximum.
Aggregate values are displayed for each segment of a summarized report.
To access aggregation operators, click the icon to the right of the field name in the Table Columns section. This opens the column properties panel. The available operators appear in the Apply Aggregation section:
Aggregation Operators for Numeric Data Types
The following aggregation operators are available for numeric data types:
This displays the sum of all values for the field. When selected, the column name changes to <Sum [Field Name]>. To remove the sum function, selectfrom the drop-down.
This option is available for numeric fields only. This displays the average of all values for the field.
This option is available for numeric fields only. This displays the minimum value for the field.
This option is available for numeric fields only. This displays the maximum value for the field.
Aggregation Operators for All Data Types
The following aggregation operators are available for all data types:
This option gives you a total count of the values within a field. When you select theoption, the word "Count" is added to the title of the column.
For example, you are creating a Transaction Custom Report and would like to know the total number of credit and debit transactions in your portal. You add the Transaction User field and the Transaction Type field to the report. You apply the option to the Transaction User field, and then you open the Preview panel. The report previews an aggregate of the number of transactions within each transaction type. You return to the Builder tab and filter the Transaction Type field by "Credit" and "Debit." Back on the Preview panel, you find that the report is filtered to show only credit and debit transactions. The count operator at the bottom of the report gives you the total number of credit and debit transactions in your portal.
This option gives you a total count of the unique values within a field. When you select theoption, the words "Count Unique" are added to the title of the column.
For example, you are creating a Training Custom Report and would like to know the total number of training items that are in each training type. This will help you see which training types have the most training items and which training types have the least training items. To do this, you add the Training Type field and the Training Title field to the report. For the Training Title field, you apply the option from the aggregation operators in the column properties panel. You go to the Preview panel and find that the report shows a list of each training type, along with the number of training items within each training type.