Page Comparison

{anchor:top}
h2. Overview
{styleclass: Class=topLink}[top|#top]{styleclass}
OneWhen writing ofreports theyou firstwill thingsoften thathave youa mayneed noticeto whensummarise buildingfigures arather reportthan isdisplaying thattransaction yourlevel data (that is, at too low a level.  For example you may want to know the total revenue for a year but the report is bringing back every transaction for the years selected.  In this example you need to aggregate the data in your report. You need to sum revenue for the year. 

!x.png!

Yellowfin includes standard aggregation functions (sum, count, average, minimum, maximum and percentage) that enable you to make quick calculations on the data in reports.  The choice of metric applied is determined by the aggregation menu buttons.

|!rpt_sum.png!|*Sum* of all values returned|
|!rpt_avg.png!|*Average* value of the items returned|
|!rpt_min.png!|*Minimum* value returned|
|!rpt_max.png!|*Maximum* value returnedreturning individual transactions rather than a total or count). Aggregations are the method used to summarise fields.

!x.png!

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. Changing Aggregation
{styleclass: Class=topLink}[top|#top]{styleclass}
To change a metric aggregation, complete the following:
# Move your cursor over the metric object in the box and click on the metric name.  The item will now be highlighted.   
# Now select the aggregation type that you wish to apply - you will notice that the icon on the left hand side of the 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.

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