Aggregation functions

  • Updated

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

The following is a list of aggregators available in Analytics:

  • avg – Compute the average of the input values.
  • count – Count the total number of input values, including duplicates.
  • unique count – Count the number of unique input values.
  • first – Compute the first input value, ordered by event time.
  • last – Compute the last input value, ordered by event time.
  • max – Compute the maximum input value.
  • min – Compute the minimum input value.
  • sum – Compute the sum of input values.