Calculation methods

Most charts allow you to select the calculation method. The nice calculation methods are:

Average: Average value of the selected field.
Count: Number of records (rows).
Count (unique): Number of records (rows) but removing duplicates (depending on the fields selected).
First: Returns the first value based on the selected sorting criteria. You must also select the field that will be used to sort the records. The system will then return the first value according to the specified sort order.
Last: Returns the last value based on the selected sorting criteria. You must also select the field that will be used to sort the records. The system will then return the last value according to the specified sort order.
Maximum: Returns the largest value from the selected records.
Minimum: Returns the smallest value from the selected records.
Running total: Sum of the selected field (cumulated over time).
Sum: Sum of the selected field.

Note: The availability of the First and Last calculation methods depends on the visualization type.

Using the dataset presented above, you could do the following calculations:

Average	Average duration of activities per activity type Calculation= Average. Field= Duration. Rows= Activity type.
Count	Number of participations per year (if participants attend many activities, each activity/participant counts) Calculation=Count. Field=Name. Rows=year.
Count (unique)	Number of participations per year (if participants attend many activities, only 1 activity/participant counts) Calculation=Count(unique). Field=Name. Rows=year.
Running total	Total of hours participated per person by year (cumulated - and not just hours that were actually done during that period). Calculation= Running total. Field=Duration. Rows=Year. Columns=Name.
Sum	Total of hours participated per person per year. Calculation= Sum. Field=Duration. Rows=Year. Columns=Name.