# Aggregate Functions Aggregate functions evaluate multiple rows of data to return a single value. For example, you can use aggregate functions to perform group calculations (like **Sum** and **Avg**), retrieve specific values (like **Min** and **Max**), assess the data to provide insights (like **Count** and **CountDistinct**), or join multiple values (like **ArrayAgg** and **ListAgg**). | Function | Explaination | | ---------------------------------------------------------------------------------------------------------------------------------------------------------- | --------------------------------------------------------------------------------------------------------------------------------------------------------- | | [arrayagg](https://support.meetuma.ai/uma-knowledgebase/data-and-reporting/analytics-pro/functions/aggregate-functions/arrayagg "mention") | Identifies non-null row values in a column or group and aggregates them into a single array. | | [arrayaggdistinct](https://support.meetuma.ai/uma-knowledgebase/data-and-reporting/analytics-pro/functions/aggregate-functions/arrayaggdistinct "mention") | Identifies distinct non-null row values in a column or group and aggregates them into a single array. | | [avg](https://support.meetuma.ai/uma-knowledgebase/data-and-reporting/analytics-pro/functions/aggregate-functions/avg "mention") | Calculates the average value of a column or group. | | [avgif](https://support.meetuma.ai/uma-knowledgebase/data-and-reporting/analytics-pro/functions/aggregate-functions/avgif "mention") | Calculates the average value of a column or group *when the specified condition is* `True`. | | [corr](https://support.meetuma.ai/uma-knowledgebase/data-and-reporting/analytics-pro/functions/aggregate-functions/corr "mention") | Calculates the Pearson correlation coefficient (bivariate correlation) of two columns. | | [count](https://support.meetuma.ai/uma-knowledgebase/data-and-reporting/analytics-pro/functions/aggregate-functions/count "mention") | Counts the number of non-null and non-empty values in a column or group. | | [countdistinct](https://support.meetuma.ai/uma-knowledgebase/data-and-reporting/analytics-pro/functions/aggregate-functions/countdistinct "mention") | Counts the number of unique non-null and non-empty values in a column or group. Does not count duplicate values. | | [countdistinctif](https://support.meetuma.ai/uma-knowledgebase/data-and-reporting/analytics-pro/functions/aggregate-functions/countdistinctif "mention") | Counts the number of unique non-null and non-empty values in a column or group *when the specified condition is* `True`. Does not count duplicate values. | | [countif](https://support.meetuma.ai/uma-knowledgebase/data-and-reporting/analytics-pro/functions/aggregate-functions/countif "mention") | Counts the number of non-null and non-empty values in a column or group *when the specified condition is* `True`. | | [grandtotal](https://support.meetuma.ai/uma-knowledgebase/data-and-reporting/analytics-pro/functions/aggregate-functions/grandtotal "mention") | Calculates the grand total for column or group. | | [listagg](https://support.meetuma.ai/uma-knowledgebase/data-and-reporting/analytics-pro/functions/aggregate-functions/listagg "mention") | Joins the values of a group or column into a single text string. | | [listaggdistinct](https://support.meetuma.ai/uma-knowledgebase/data-and-reporting/analytics-pro/functions/aggregate-functions/listaggdistinct "mention") | Joins the unique values of a group or column into a single text string. Does not include duplicate values. | | [max](https://support.meetuma.ai/uma-knowledgebase/data-and-reporting/analytics-pro/functions/aggregate-functions/max "mention") | Retrieves the maximum (largest or latest) value in a column or group. | | [maxif](https://support.meetuma.ai/uma-knowledgebase/data-and-reporting/analytics-pro/functions/aggregate-functions/maxif "mention") | Retrieves the maximum (largest or latest) value in a column or group *when the specified condition is* `True`. | | [median](https://support.meetuma.ai/uma-knowledgebase/data-and-reporting/analytics-pro/functions/aggregate-functions/median "mention") | Determines the median (midpoint) value of a column or group. | | [min](https://support.meetuma.ai/uma-knowledgebase/data-and-reporting/analytics-pro/functions/aggregate-functions/min "mention") | Retrieves the minimum (smallest or earliest) value in a column or group. | | [minif](https://support.meetuma.ai/uma-knowledgebase/data-and-reporting/analytics-pro/functions/aggregate-functions/minif "mention") | Retrieves the minimum (smallest or earliest) value in a column or group *when the specified condition is* `True`. | | [percentilecont](https://support.meetuma.ai/uma-knowledgebase/data-and-reporting/analytics-pro/functions/aggregate-functions/percentilecont "mention") | Calculates the continuous kth percentile of a column or group. | | [percentiledisc](https://support.meetuma.ai/uma-knowledgebase/data-and-reporting/analytics-pro/functions/aggregate-functions/percentiledisc "mention") | Calculates the discrete kth percentile of a column or group. | | [percentoftotal](https://support.meetuma.ai/uma-knowledgebase/data-and-reporting/analytics-pro/functions/aggregate-functions/percentoftotal "mention") | Calculates the percentage a value contributes to the specified aggregate total. | | [stddev](https://support.meetuma.ai/uma-knowledgebase/data-and-reporting/analytics-pro/functions/aggregate-functions/stddev "mention") | Calculates the standard deviation of a column or group. | | [subtotal](https://support.meetuma.ai/uma-knowledgebase/data-and-reporting/analytics-pro/functions/aggregate-functions/subtotal "mention") | Calculates the subtotal of a column or group. | | [sum](https://support.meetuma.ai/uma-knowledgebase/data-and-reporting/analytics-pro/functions/aggregate-functions/sum "mention") | Calculates the sum of a column or group. | | [sumif](https://support.meetuma.ai/uma-knowledgebase/data-and-reporting/analytics-pro/functions/aggregate-functions/sumif "mention") | Calculates the sum of a column or group *when the specified condition is* `True`. | | [sumproduct](https://support.meetuma.ai/uma-knowledgebase/data-and-reporting/analytics-pro/functions/aggregate-functions/sumproduct "mention") | Calculates the product of row values across specified columns, then calculates the sum of the resulting products for a column or group. | | [variance](https://support.meetuma.ai/uma-knowledgebase/data-and-reporting/analytics-pro/functions/aggregate-functions/variance "mention") | Estimates the sample variance (spread of distribution) of a column or group. | | [variancepop](https://support.meetuma.ai/uma-knowledgebase/data-and-reporting/analytics-pro/functions/aggregate-functions/variancepop "mention") | Calculates the population variance (spread of distribution) of a column or group. | --- # Agent Instructions: 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: ``` GET https://support.meetuma.ai/uma-knowledgebase/data-and-reporting/analytics-pro/functions/aggregate-functions.md?ask= ``` The question should be specific, self-contained, and written in natural language. 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.