Most charts allow you to select a calculation method. The 5 calculation methods are:
- Average: Average value of the selected field.
- Count: Number of records (rows).
- Count(unique): Number of records (rows) but removes duplicates (based on selected fields).
- Running total: Sum of the selected field (accumulated through time).
- Sum: Sum of the selected field.
With the example dataset presented above, you could do the following calculations: