Aggregations
Everything on SkillVeris tagged Aggregations — collected across the glossary, study notes, blog, and cheat sheets.
9 resources across 2 libraries
Study Notes(8)
Aggregations and Grouping
Master aggregate functions and GROUP BY/HAVING to summarize rows into meaningful totals, averages, and counts in SQL Server.
Aggregation Performance
Learn what drives aggregation performance in Elasticsearch, doc_values, shard sizing, caching, and approximate algorithms, and how to keep large aggregations f…
Aggregations vs SQL GROUP BY
Compare Elasticsearch's aggregation framework to SQL's GROUP BY and aggregate functions, covering conceptual mapping, execution model differences, and when to…
Bucket Aggregations
Understand how Elasticsearch's bucket aggregations group documents by terms, ranges, and dates, and how they nest with metric aggregations for multi-level brea…
Metric Aggregations
Learn how Elasticsearch's metric aggregations compute single- and multi-value numeric summaries like avg, sum, cardinality, and percentiles over matched docume…
Nested Aggregations
Learn how the nested and reverse_nested aggregations let Elasticsearch correctly aggregate over arrays of objects mapped with the nested field type.
Aggregation Functions
Explore the built-in and custom aggregation functions available after groupby, including agg() for applying multiple statistics at once.
Aggregations and Statistics
NumPy provides fast, axis-aware aggregation functions like sum, mean, std, and var, plus NaN-safe variants for handling missing values in numerical data.