We recommend switching to the latest versions of Edge, Firefox, Chrome or Safari. Using Internet Explorer will result in a loss of website functionality.
Our Support systems migrated on Saturday, May 21. We'll automatically forward you to the new location for this content.

Articles in this section

See more

Using the Aggregate Node

Avatar
Janice Mok
Follow

Learn how to aggregate your data based on a user specified field or fields and from the grouped data, output calculations/operations. These operations are:

  • Count of the records per group
  • Sum of the records per group based on a user specified field
  • Average of the records per group based on a user specified field
  • Min or Max – which Outputs the smallest or largest number in the group
  • First or Last – which Outputs the First or last record in the group
  • Sample or Population StDev – Outputs a Standard deviation of all of the values for the specified field within the group.
  • Sample or Population Variance – Outputs an Average of the squared differences from the mean

 

Related articles

Comments

0 comments

Please sign in to leave a comment.