Aggregations

Modified on Thu, 25 Apr 2024 at 04:39 PM

Introduction


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).



To Aggregate, simply Navigate to the bottom of your sheet, and select the dropdown.


No-Code Big Data Aggregation

Aggregate with 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)


Text Aggregations

  • First Value (the value of the first item in the group based on the current sort)
  • Last Value (the value of the last item in the group based on the current sort)
  • Row Count
  • Empty
  • Filled 
  • Unique
  • Percent Empty
  • Percent Filled
  • Percent Unique

Check out this demo:




Was this article helpful?

That’s Great!

Thank you for your feedback

Sorry! We couldn't be helpful

Thank you for your feedback

Let us know how can we improve this article!

Select atleast one of the reasons
CAPTCHA verification is required.

Feedback sent

We appreciate your effort and will try to fix the article