Measures and aggregations
A report's measure is the number it calculates: a count of entries, or the sum, average, minimum, or maximum of one field. Only number, price, currency, and rollup fields can be summed or averaged, so a value you want to total has to be stored as one of those types.
A report's measure is the number it calculates: a count of entries, or the sum, average, minimum, or maximum of one field. Only number, price, currency, and rollup fields can be summed or averaged, so a value you want to total has to be stored as one of those types.
Requirements
A role that can build reports. See Build a report.
The measures
| Measure | What it gives | Needs a field |
|---|---|---|
| Count | How many entries | No |
| Sum | The total of a field | Yes |
| Average | The mean of a field | Yes |
| Minimum | The smallest value | Yes |
| Maximum | The largest value | Yes |
Which fields can be measured
- Number and price fields.
- Currency fields: the amount is measured; the currency code is not part of the result.
- Rollup fields: a value already computed from related entries, such as each client's total placement fees, can itself be summed or averaged across clients.
Text, options, and dates cannot be summed. To count entries by an option, use Count and group by the option; see Chart types.
A worked example
A staffing firm wants average fee per placement this quarter, by recruiter. Measure: Average of the Fee field. Group by: Recruiter. Time window: this quarter, on the placement's start date; see Filters and date ranges in reports. Changing the measure to Count shows how many placements each recruiter made in the same quarter.
Notes and limitations
- No ratios. A measure is one calculation on one field; a ratio such as fee per hour is not available as a measure. Store the ratio as its own number field if you need to report on it.
- Currencies are not converted. The result carries no currency code, so if entries hold amounts in different currencies, filter the report to one currency to get a meaningful total.
- Empty values add nothing to a sum and are left out of an average.
- Live values. Measures are calculated when the report runs, from the entries as they are now.
Related
For how reports work, see How reports work; for rollups, Rollup vs lookup.