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:

No-Code Big Data Aggregation

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: