Skip to content
Free public beta until December 4, 2026: every course is open, no card needed. After that, the first chapter of each course stays free and full access is a one-time $39 ($19 for up to 100 founding members chosen for helpful feedback). Your progress is kept. How the beta works

aggregate

One number that summarises many readings, such as their average or maximum.

An aggregate function (count, min, max, mean, sum) reduces the points in a group or window to one value.

Examples

  • For each hour, the greenhouse query returns AVG, MIN, MAX and COUNT of temp_c, turning dozens of readings into the avg_c, min_c and max_c columns.

Read the full section →