Calculation methods
Calculation methods
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.
Examples
With the example dataset presented above, you could do the following calculations:
Average |
|
Count |
|
Count(unique) |
|
Running total |
|
Sum |
|