Overview
Aggregation refers to the process of summarizing and grouping data from multiple records. FastField provides several built-in aggregation functions that allow you to calculate the sum, average, or count of a particular field. For example, you could use the sum function to calculate the total amount of sales for a particular product.
Aggregation Types
Count
- A count can be defined as the act of determining the quantity or the total number of objects in a set or a group. Thus, counting numbers can be used to determine the total amount of things.
- E.g., 20 Barrels weighed today
Average
- An average is a number expressing the central or typical value in a set of data. The average is calculated by dividing the sum of the total values in the set by their number.
- E.g., 500lbs is the average weight
Minimum
- The minimum is the minimum value recorded in a set of data.
- E.g., A Barrel weighed today at 412 lbs
Maximum
- The maximum is the maximum value recorded in a set of data.
- E.g., A Barrel weighed today at 555 lbs
Sum
- The sum is the total amount resulting from adding two or more numbers, amounts, or items.
- E.g., Total weight today is 23,192 lbs