> For the complete documentation index, see [llms.txt](https://upsolver.gitbook.io/content/llms.txt). Markdown versions of documentation pages are available by appending `.md` to page URLs; this page is available as [Markdown](https://upsolver.gitbook.io/content/reference-1/functions-and-operators/functions/aggregate.md). # Aggregate Aggregate functions perform a calculation on multiple values to return a single result. The following functions can be included in your jobs:

Function	Description
APPROX_COUNT_DISTINCT	Approximates the number of distinct non-null input values.
APPROX_COUNT_DISTINCT_EACH	Approximates the number of distinct values for each given group.
AVG	Computes the average (arithmetic mean) of all input values.
AVG_EACH	Computes the average (arithmetic mean) of all input values for each given group.
AVG_TIME_SERIES	Gets the average value per time interval.
COLLECT_SET	Collects a set of all values for a given field.
COLLECT_SET_EACH	Collects a set of all values for a field for each given group.
COUNT	Counts the number of non-null input values.
COUNT(*)	Counts the number of input rows.
COUNT(DISTINCT ...)	Counts the number of distinct non-null input values.
COUNT_EACH	Counts the number of items for each given group.
COUNT_IF	Counts the number of `TRUE` input values.
DYNAMIC_SESSIONS	Collects an array of session start and end times.
FIRST	Gets the first input value to arrive for each group.
FIRST_ARRAY	Gets the first array of values seen in the events within the time window.
FIRST_EACH	Gets an array of the first values per given group in the time window.
FIRST_TIME_SERIES	Gets the first value per time interval.
LAST	Gets the last input value to arrive for each group.
LAST_ARRAY	Gets the last array of values seen in the events within the time window.
LAST_EACH	Gets an array of the last values per group in the time window.
LAST_K	Gets the last `k` values per group.
LAST_K_EACH	Gets the last `K` values per given group.
LAST_TIME_SERIES	Gets the last value per time interval.
MAX	Computes the maximum of all input values.
MAX_BY	Gets the value that corresponds to the maximum value of a different field in the time window.
MAX_EACH	Collects the maximum value per given group.
MAX_TIME_SERIES	Gets the maximum value per time interval.
MIN	Computes the minimum of all input values.
MIN_BY	Gets the value that corresponds to the minimum value of a different field in the time window.
MIN_EACH	Collects the minimum value per given group.
MIN_TIME_SERIES	Gets the minimum value per time interval.
SESSION_COUNT	Counts the number of sessions.
STD_DEV	Computes the standard deviation of a set of numbers.
STD_DEV_EACH	Computes the standard deviation of a set of numbers per given group.
STRING_MAX	Computes the maximum of all input string values.
STRING_MAX_EACH	Collects the maximum string value per given group.
STRING_MIN_EACH	Collects the minimum string value per given group.
SUM	Computes the sum of all input values.
SUM_EACH	Computes the sum of all input values for each given group.
SUM_TIME_SERIES	Gets the sum of all values per time interval.
WEIGHTED_AVERAGE	The weighted average of a field in the time window.

--- # Agent Instructions This documentation is published with GitBook. GitBook is the documentation platform designed so that both humans and AI agents can read, navigate, and reason over technical content effectively. Learn more at gitbook.com. ## Querying This Documentation If you need additional information that is not directly available in this page, you can query the documentation dynamically by asking a question. Perform an HTTP GET request on the current page URL with the `ask` query parameter, and the optional `goal` query parameter: ``` GET https://upsolver.gitbook.io/content/reference-1/functions-and-operators/functions/aggregate.md?ask=&goal= ``` `ask` is the immediate question: it should be specific, self-contained, and written in natural language. `goal` is optional and describes the broader end goal you are ultimately trying to accomplish on behalf of the user. GitBook uses it to tailor the answer towards what is most useful for that goal. The response will contain a direct answer to the question and relevant excerpts and sources from the documentation. Use this mechanism when the answer is not explicitly present in the current page, you need clarification or additional context, or you want to retrieve related documentation sections.