Gigasheet Aggregations make it easy to calculate summary statistics for a given column. This is similar to a formula in a spreadsheet, but doesn't require you to learn any special formula syntax. The example below shows how to count unique values in a column, and how to calculate a sum and an average. See important details on Aggregations below (and the demo at the bottom of the page).
Aggregations work best when used with Groups:
Aggregations can also operate without Groups:
Aggregations operate on filtered values only. If a filter removes rows from a group, the aggregation for the group only considers rows remaining after the filter is applied.
Numeric Aggregations:
- Sum (total)
- Average (mean)
Numeric and Date-time Aggregations:
- First (the value of the first item in the group based on the current sort)
- Last (the value of the last item in the group based on the current sort)
- Min (smallest value or earliest date)
- Max (largest value or latest date)
- Range (difference smallest and largest value; for datetime this is number of days)
Count Aggregations:
- Count (number of rows in the group)
- Distinct Count (number of unique values)
- Distinct Percentage (Distinct Count / Count)
Missing Data Aggregations
Blank (number of blank cells)
Not blank (number of filled cells)
Percent Blank
Percent Not Blank
Check out this demo: