Page Comparison

{anchor:top}
h2. Overview
{styleclass: Class=topLink}[top|#top]{styleclass}
When writing reports you will often have a need to summarise figures rather than displaying transaction level data (that is, returning individual transactions rather than a total or count). Aggregations are the method used to summarise fields. The aggregation functions available are *Sum*, *Average*, *Min*, *Max*, *Count*, and *Count Distinct*. 

|!rpt_sum.png!|*Sum* of all values returned in the table. These sums may be split up by dimension fields to create sums for each category value. For example, the sum invoiced amount by each year.|
|!rpt_avg.png!|*Average* value of the items returned in the table. The average may be split up by dimension fields to create averages for each category value. For example, average age of customer by demographic.|
|!rpt_min.png!|*Minimum* value returned in the table. These may be split up by dimension fields to find the minimum value for each category value. For example, the minimum rating per camp.|
|!rpt_max.png!|*Maximum* value returned in the table. These may be split up by dimension fields to find the maximum value for each category value. For example, the maximum number of complaints by telephone operator.|
|!rpt_count.png!|*Count* of the number of items returned in the table. These may be split up by dimension fields to find the number of items for each category value. For example, count the number of calls received by operator, by hour.|
|!rpt_count_dist.png!|*Count* of the number of *Distinct* items returned in the table. These may be split up by dimension fields to find the number of distinct items for each category value. For example, count the number of customers who called, by operator, by hour.|

 
h2. Applying an Aggregation
{styleclass: Class=topLink}[top|#top]{styleclass}
To add and aggregation to a field, complete the following:
# Click on the field's drop down menu once it had been added to the report. There are two ways you can do this:
## Through the Columns/Rows list
!01applyField.png!
## Through the Table Preview
!01applyTable.png!
# Select the aggregation option from the list, then choose the aggregation you wish to apply.
!02applySum.png!
# Your field should now have the aggregation applied to it, and the corresponding icon displayed in the Columns/Rows list of the Data step.
!03sumApplied.png!


h2. Changing or Removing an Aggregation
{styleclass: Class=topLink}[top|#top]{styleclass}
To change athe metric aggregation, completeapplied theto following:a #field, Moveor yourremove cursorit, overcomplete the metricfollowing:
object# in the box and click Click on the metric name.  The item will now be highlighted.   
# Now selectfield's drop down menu (using either of the options described above)
# Select the aggregation type that you wish to apply - you will notice thatoption from the iconlist, onthen theeither leftchoose handan sidealternative ofaggregation, theor measure object will be updated with a new icon to indicate the aggregation applied.  
!x.png!
 

h2. Removing Aggregation
{styleclass: Class=topLink}[top|#top]{styleclass}
To remove an aggregation or advanced function from a field, do one of the following:
# Reset the calculation by selecting the metric and clicking the clear link.
# Remove the measure from the report entirely by dragging it out of the columns section.*None* to remove the current aggregation

\\
\\
{horizontalrule}
{styleclass: Class=topLink}[top|#top]{styleclass}