Tableau is a top-rated Data Visualization tool. Tableau is a self-service BI and analytics tool, capable of building compelling visualizations. Being a BI and analytics tool, it is sometimes necessary to perform some actions on data to bring it in an accessible format. Tableau has a specific set of functions to change the data in some way. These functions are called as “Aggregate Functions” in Tableau. For example, Average, summation, etc.
Read More: What is Tableau?
Tableau Aggregate Functions
The following are the aggregate functions in Tableau:
- AVG – Average
- ATTR – Asterisk
- COLLECT – Collect
- CORR – Correlation
- COUNT – Count
- COUNTD – Discount Count
- COVAR – Covariance
- COVARP – Covariance based on Population
- MAX – Maximum
- MIN – Minimum
- MEDIAN – Median
- PERCENTILE – Percentile
- STDEV – Standard Deviation
- STDEVP – Standard Deviation based on Population
- SUM – Sum
- VAR – Variance
- VARP – Variance based on Population
It returns the mean value of all the expressions involved. It ignores null values.
AVG ([Sales]) = 200
It returns only a single value of the whole row calculated. It ignores the null values, and if the conditions are not met will return asterisk.
ATTR ([country]) = India
It combines the values that are in argument fields, and it is used for spatial domains. It ignores null values.
It represents correlation and returns -1 for negative, 0 for no relation and 1 for positive changes when two variables are compared.
CORR (expression 1, expression 2)
CORR (1, 2) = -1
Read More: Tableau Date Functions
It returns the number of values present in selected in a column. It ignores the null values.
COUNT ([Sales ID]) = 5432
It returns the distinct count of the column or group. It ignores the null values.
COUNTD (‘Country’) = 256
It represents the covariance between two expressions where the positive outcome indicates that the variable moving in the right direction.
COVAR (expression 1, expression 2)
The only difference between COVAR and COVARP that COVARP is based on population.
COVARP (expression 1, expression 2)
It returns the maximum values from the expression.
MAX ([Age]) = 107
It returns the middle value of the given expression.
MEDIAN (1, 2, 3, 4, 5, 6, 7) = 4
It returns the minimum value of the given expression.
MIN ([Sales Rate]) = 4
It returns the percentile value of the given expression between 0 and 1. If a decimal number is delivered, it will return the median value.
Percentile (Expression, number)
Percentile ([Sales], 0.54) = 37.69
It returns the high or low deviation values.
Same as STDEV, the only difference is STDEVP is based on population.
It returns the sum value of the given numeric values. It ignores the null values.
SUM (1, 2, 3) = 6
It returns the variance in a given expression.
It is same as variance, but it is based on population
In this article, we discussed all the aggregate functions in Tableau along with syntax and possible examples for better understanding.