Aggregate Field

The Aggregate Field is used to summarize or aggregate numeric information from fields in a Form Table, Dataset, or Process.

Supported functions include Sum, Count, Min, Max, and Average, enabling quick data analysis by performing calculations on selected data points.

Calculations are always performed based on the chosen table or dataset context.

Properties

Define the field Title, ID, and aggregation settings for precise control over how results are calculated and displayed.

Field Settings

See Basic Field Settings for details on general properties like Title and ID.

Number of Decimals

Controls the numeric precision of results. Define how many decimal places should be displayed to ensure outputs match the accuracy required.

Data Source

Aggregates can pull values from the following sources:

• Form Table
• Dataset
• Process

After selecting the source, choose the table or dataset name, then select a numeric field. Finally, pick the aggregation type (SUM, COUNT, MIN, MAX, or AVERAGE).

Functions

The following aggregation functions are supported:

• SUM: Returns the total of all values.
• COUNT: Returns the number of records.
• AVERAGE: Returns the mean of all values.
• MIN: Returns the smallest value.
• MAX: Returns the largest value.

Filters

Apply filters to refine which records are included in the calculation. For details, see the Filter Page.