Aggregators
An aggregator in Carrot appears as a word followed by curly brackets, which contain an expression. All aggregators are case-insensitive.
Aggregation is only available in reports. Smart calculations and buckets only evaluate data of an individual person or job.
An aggregator performs a calculation on an expression and returns a Number value based on the aggregator's logic.
Aggregator | Description |
count{} | Counts the number of times a given expression evaluates to a truthy value. All non-truthy values, such as null, an empty string, 0, or false are discarded. |
max{} | Returns the largest value of a given expression. All non-numeric values are discarded. |
mean{} | Returns the average of all values of a given expression. All non-numeric values are discarded. |
min{} | Returns the smallest value of a given expression. All non-numeric values are discarded. |
sum{} | Returns the sum of all values of a given expression. All non-numeric values are discarded. |