Field aggregators

Field aggregators specify how Data Explorer interprets the data to apply a default mathematical operation to consolidate the data. This is helpful when the data in a field is processed in the same manner, such as calculating sums of Sales.

The available aggregators for a field depend on the type of data it contains, such as text or number. Data Explorer automatically applies an aggregator to each data type, using Latest for text and date, and Sum for number fields. You can change the default aggregator when mapping or editing your fields.

Aggregation can also be specified when selecting a measure for a report.

Aggregator options

Data Explorer currently includes the aggregators in this table.

Aggregator	Compatible Field Type	Description
Avg	Number	The average/arithmetic mean of all the values. Null values are not included in the calculation.
Count	Number, text, date	The count of all the available data. Null values are not included in the count.
DistinctCount	Number, text, date	The count of all the unique values.
DistinctValues	Number, text, date	The list of unique values.
Latest	Number, text, date	The last recorded value. This is the default aggregator used for text and date fields.
Max	Number, text, date	The largest value. Number—the highest numerical value Text—the lexicographically sorted last value Date—the latest date
Median	Number	The arithmetic middle of all the values.
Min	Number, text, date	The smallest value. Number—the lowest numerical value Text—the lexicographically sorted first value Date—the earliest date
StdDev	Number	Standard deviation. The measure of the extent of variation or dispersion within the data, or how spread out numbers are within the data.
Sum	Number	The sum of the values. This is the default aggregator used for number fields.