Versions Compared

Old Version 1

changes.mady.by.user Pawel Huszcza (Unlicensed)

Saved on

compared with

New Version Current

changes.mady.by.user Chris Welford

Saved on

Key

  • This line was added.
  • This line was removed.
  • Formatting was changed.

Aggregate functions are available in stream views and pipes. Aggregate functions aggregate data, often grouped by other attributes, to give totals, max, min, avg values etc. for each key value, e.g. for each customer, region.

FunctionDescription
Average

This function returns the arithmetic average value of an attribute from records with the same key value.

In detail, it returns the sum of all values for a key value, divided by the number of values that are not null.

It is only available for numeric attributes.

CountThis function returns the number of non-null values of an attribute from records with the same key value.
DistinctThis function returns the number of unique values of an attribute from records with the same key value.
Maximum

This function returns the maximum value of an attribute from records with the same key value.

It is available for numeric, string and date/time attributes.

Strings are ordered alphabetically, with the shortest strings first.

Minimum

This function returns the minimum value of an attribute from records with the same key value.

It is available for numeric, string and date/time attributes.

 Strings are ordered alphabetically, with the shortest strings first.

Percent

This function can be applied to a numeric field, to return the percentage of the sum of values for each key value in relation to the total sum of values.

You should use this function in conjunction with one or more grouping attributes - each combination of values from these grouping attributes gives a key value.

For example, you have a stream with 2 fields:

NumberLabel
12A
14B
13C
10A
5A
2

B

and you create a grid view:

  • dragging in the attribute Label - which automatically becomes a grouping attribute when one or more of the other attributes are aggregated
  • dragging in the attribute Number, and applying the aggregate function Percent
  • setting the rounding on the stream view attribute Number to 2 decimal places

This will give the view:

NumberLabel
48.22A
28.57B
23.21C


Sum

This function returns the sum of all values of an attribute from records with the same key value.

It is only available for numeric attributes.