Aggregate Functions
Aggregate Functions
For the aggregate functions, Cumulative Sum and Cumulative Percent, see View Attribute. This is the list of available aggregate functions. 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. This function returns the number of unique values of an attribute from records with the same key value. There is no single attribute function equivalent of the distinct pipe function. 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. 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. The percent function is only available for PhixFlow instances running on an Oracle database. 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 table with 2 fields: B and you create a grid view: This will give the view: 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.Function Description Average Count This function returns the number of non-null values of an attribute from records with the same key value. Distinct Maximum Minimum Percent Number Label 12 A 14 B 13 C 10 A 5 A 2 Label
- which automatically becomes a grouping attribute when one or more of the other attributes are aggregatedNumber
, and applying the aggregate function PercentNumber
to 2 decimal placesNumber Label 48.22 A 28.57 B 23.21 C Sum