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