Aggregation Functions

  • Updated

Overview​

Aggregate blocks calculate a summary of a property or block. The calculation involves applying an aggregation function to the input property and potentially organizing its results into groups. Aggregation functions are the functions used to aggregate input for a block.

Aggregators​

Below is the list of aggregators available in Analytics:

  • avg - Computes the average of the values in the input provided.
  • count - Counts the total number of values in the input provided, including duplicates.
  • unique count - Counts the number of unique values in the input provided.
  • first - Computes the first value in the input provided. The first value is determined by ordering all inputs by event time.
  • last - Computes the last value in the input provided. The last value is determined by ordering all inputs by event time.
  • max - Computes the maximum value in the input provided.
  • min - Computes the minimum value in the input provided.
  • sum - Sums all the values in the input provided.