Overview

Aggregate functions, often grouped by other attributes, give totals, max, min, average values etc. for each key value they are provided. For example, you can sum the amount of all the lines on an invoice based on an invoice number.

Aggregate functions are available to use on stream views and pipes.

Aggregating with a Pipe

To configure a pipe for aggregation

1. Click on a pipe to open its properties.
2. In the Aggregate Attributes section, click the plus button to add a new attribute.
3. Complete the details:
   1. A Function: select the function you wish to perform e.g. sum. A complete list is provided in the function section at the end of this page.
   2. Attribute: select the attribute you wish to perform the function on.
   3. Name: name your new attribute.
4. Aggregation on a pipe takes place across all groups of data. Therefore you can define which attribute(s) you wish to group on by adding these to sort/group, or if no grouping is provided aggregation takes place across all records. 
5. Click 

   Insert excerpt
   _finish _finish nopanel true

    to save your changes.
6. The table connected to the end of the pipe can now access your attribute using its name. 

Infonote
You will not be able to cannot refer to any attributes in the source table for which there is no grouping or aggregate attribute.

Aggregating with a Table

1. Click on the pipe connecting to an Aggregate Table to open its properties.
2. Aggregation takes place across all groups of data. Therefore you can define which attribute(s) you wish to group on by adding these to Sort/Group, or if no grouping is provided aggregation takes place across all records.
3. Click 

   Insert excerpt
   _finish _finish nopanel true

    to save your changes.
4. The Aggregate Table has access to all attributes on the incoming pipe.
5. In the Attribute expressions,
   • Use functions to aggregate values e.g. sum(in.Amount) will sum up all amounts within a group.
   • Where multiple values exist for a group they will be treated as an array.
     Use a
   fullstop
   • full stop suffix after the attribute
   name 
   • name followed by a number to obtain the record from a group in that position.
   e.g.
   • 
     For example in.Name.1 will take the first name in a group.
     Alternatively, use the Functions built into PhixFlow to select the required value.

Aggregate Examples

See Using an Aggregate Table

Aggregate Functions

This is the list of available aggregate functions.