Aggregation functions allow the user to have a better understanding of the data at hand through different mathematical summaries (SUM, COUNT, AVERAGE, etc) either on grouped data or all available entries.
The Feature is only available for Filterable Result Tables (FRTs) either under view or edit mode.
Executing aggregation functions is possible in both the FRT container within the report and the FRT processor within the workflow.
The following example shows how to use aggregation functions in a report container for an FRT. The same applies for an FRT as a workflow processor.
By hovering on the column header. The currently applied function is shown. The choice selected by default would be "None".
Simply clicking on the current function will open a list of all available functions.
- The grouping functions is available for all data types.
- The available mathematical functions for numerical data types are: Count, Sum, Average, Min and Max. The default function in case an aggregation is performed on another column is the function Sum.
- The available mathematical functions for string and datetime data types are: Count, Min and Max. The default function in case an aggregation is performed on another column is the function Count.
Note that: Once the aggregation function count is performed on a column of data type string, it is transformed to a numerical data type column. Therefore the aggregation dialog will display functions relevant to a numerical type.
Setting a single aggregation function to none will set all other functions to none as well. The original data will be displayed again.
- Selecting "group" shows all distinct values for the chosen column. For all other columns the default mathematical function is applied.
- Grouping more than one column is also possible.
Here, grouping is applied on both the variety and the petal_width
- Like for aggregation the grouping is reset when "none" is selected for any column.
Filtering after applying aggregation functions on the FRT container is not possible. However, data can still be filterable using a filter container or custom SQL.
- Summaries for grouped FRT within column header.
- History for applied filter/sort/aggregate steps.
- Downloading of the whole aggregated/filtered FRT (only the page).
- Rounding of FRT results for each column separately.