# Tableau Aggregate Functions with Examples | Wirandle

## In Tableau you can aggregate measures or dimensions. 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:

1. AVG – Average
2. ATTR – Asterisk
3. COLLECT – Collect
4. CORR – Correlation
5. COUNT – Count
6. COUNTD – Discount Count
7. COVAR – Covariance
8. COVARP – Covariance based on Population
9. MAX – Maximum
10. MIN – Minimum
11. MEDIAN – Median
12. PERCENTILE – Percentile
13. STDEV – Standard Deviation
14. STDEVP – Standard Deviation based on Population
15. SUM – Sum
16. VAR – Variance
17. VARP – Variance based on Population

Top 11 Key Tableau Features that You Must Know

### 1) AVG

It returns the mean value of all the expressions involved. It ignores null values.

#### Syntax

AVG (expression)

Example

AVG ([Sales]) = 200

### 2) ATTR

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.

#### Syntax

ATTR (expression)

Example

ATTR ([country]) = India

### 3) COLLECT

It combines the values that are in argument fields, and it is used for spatial domains. It ignores null values.

#### Syntax

COLLECT (expression)

Example

COLLECT ([Geometry])

### 4) CORR

It represents correlation and returns -1 for negative, 0 for no relation and 1 for positive changes when two variables are compared.

#### Syntax

CORR (expression 1, expression 2)

Example

CORR (1, 2) = -1

Read More: Tableau Date Functions

### 5) COUNT

It returns the number of values present in selected in a column. It ignores the null values.

#### Syntax

COUNT (expression)

Example

COUNT ([Sales ID]) = 5432

### 6) COUNTD

It returns the distinct count of the column or group. It ignores the null values.

#### Syntax

COUNTD (expression)

Example

COUNTD (‘Country’) = 256

### 7) COVAR

It represents the covariance between two expressions where the positive outcome indicates that the variable moving in the right direction.

#### Syntax

COVAR (expression 1, expression 2)

### 8) COVARP

The only difference between COVAR and COVARP that COVARP is based on population.

#### Syntax

COVARP (expression 1, expression 2)

### 9) MAX

It returns the maximum values from the expression.

#### Syntax

MAX (expression)

Example

MAX ([Age]) = 107

### 10) MEDIAN

It returns the middle value of the given expression.

#### Syntax

MEDIAN (expression)

Example

MEDIAN (1, 2, 3, 4, 5, 6, 7) = 4

Learn to Create Tableau Dashboards

### 11) MIN

It returns the minimum value of the given expression.

#### Syntax

MIN (expression)

Example

MIN ([Sales Rate]) = 4

### 12) Percentile

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.

#### Syntax

Percentile (Expression, number)

Example

Percentile ([Sales], 0.54) = 37.69

### 13) STDEV

It returns the high or low deviation values.

#### Syntax

STDEV (expression)

### 14) STDEVP

Same as STDEV, the only difference is STDEVP is based on population.

#### Syntax

STDEVP (expression)

### 15) SUM

It returns the sum value of the given numeric values. It ignores the null values.

#### Syntax

SUM (expression)

Example

SUM (1, 2, 3) = 6

### 16) VAR

It returns the variance in a given expression.

VAR (expression)

### 17) VARP

It is same as variance, but it is based on population

#### Syntax

VARP (expression)

## Conclusion

In this article, we discussed all the aggregate functions in Tableau along with syntax and possible examples for better understanding.

Source link

## Comments

Loading…

0 ### 10 steps to IoT deployment success | Wirandle 