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: