Tableau Tutorial
Tableau Data Sources
Tableau Worksheets
Tableau Calculations
Tableau Sort & Filters
Tableau Charts
Tableau Advanced
Tableau Useful Resources
Selected Reading
- Tableau - Data Terminology
- Tableau - Show Me
- Tableau - Data Types
- Tableau - File Types
- Tableau - Design Flow
- Tableau - Navigation
- Tableau - Get Started
- Tableau - Environment Setup
- Tableau - Overview
- Tableau - Home
Tableau Data Sources
- Tableau - Data Blending
- Tableau - Data Joining
- Tableau - Editing Metadata
- Tableau - Fields Operations
- Tableau - Extracting Data
- Tableau - Custom Data View
- Tableau - Data Sources
Tableau Worksheets
- Tableau - Paged Workbook
- Tableau - Reorder Worksheet
- Tableau - Save & Delete Worksheet
- Tableau - Rename Worksheet
- Tableau - Add Worksheets
Tableau Calculations
- Tableau - LOD Expressions
- Tableau - Table Calculations
- Tableau - Date Calculations
- Tableau - String Calculations
- Tableau - Numeric Calculations
- Tableau - Functions
- Tableau - Operators
Tableau Sort & Filters
- Tableau - Filter Operations
- Tableau - Top Filters
- Tableau - Condition Filters
- Tableau - Context Filters
- Tableau - Quick Filters
- Tableau - Basic Filters
- Tableau - Basic Sorting
Tableau Charts
- Tableau - Waterfall Charts
- Tableau - Motion Charts
- Tableau - Histogram
- Tableau - Gantt Chart
- Tableau - Bump Chart
- Tableau - Tree Map
- Tableau - Box Plot
- Tableau - Bullet Graph
- Tableau - Bubble Chart
- Tableau - Scatter Plot
- Tableau - Crosstab
- Tableau - Pie Chart
- Tableau - Line Chart
- Tableau - Bar Chart
Tableau Advanced
Tableau Useful Resources
Selected Reading
- Who is Who
- Computer Glossary
- HR Interview Questions
- Effective Resume Writing
- Questions and Answers
- UPSC IAS Exams Notes
Tableau - Functions
Tableau - Functions
Any data analysis involves a lot of calculations. In Tableau, the calculation editor is used to apply calculations to the fields being analyzed. Tableau has a number of inbuilt functions which help in creating expressions for complex calculations.
Following are the description of different categories of functions.
Number Functions
String Functions
Date Functions
Logical Functions
Aggregate Functions
Number Functions
These are the functions used for numeric calculations. They only take numbers as inputs. Following are some examples of important number functions.
| Function | Description | Example |
|---|---|---|
| CEILING (number) | Rounds a number to the nearest integer of equal or greater value. | CEILING(2.145) = 3 |
| POWER (number, power) | Raises the number to the specified power. | POWER(5,3) = 125 |
| ROUND (number, [decimals]) | Rounds the numbers to a specified number of digits. | ROUND(3.14152,2) = 3.14 |
String Functions
String Functions are used for string manipulation. Following are some important string functions with examples
| Function | Description | Example |
|---|---|---|
| LEN (string) | Returns the length of the string. | LEN("Tableau") = 7 |
| LTRIM (string) | Returns the string with any leading spaces removed. | LTRIM(" Tableau ") = "Tableau" |
| REPLACE (string, substring, replacement) | Searches the string for substring and replaces it with a replacement. If the substring is not found, the string is not changed. | REPLACE("GreenBlueGreen", "Blue", "Red") = "GreenRedGreen" |
| UPPER (string) | Returns string, with all characters uppercase. | UPPER("Tableau") = "TABLEAU" |
Date Functions
Tableau has a variety of date functions to carry out calculations involving dates. All the date functions use the date_part which is a string indicating the part of the date such as - month, day, or year. Following table psts some examples of important date functions.
| Function | Description | Example |
|---|---|---|
| DATEADD (date_part, increment, date) | Returns an increment added to the date. The type of increment is specified in date_part. | DATEADD ( month , 3, #2004-04-15#) = 2004-0715 12:00:00 AM |
| DATENAME (date_part, date, [start_of_week]) | Returns date_part of date as a string. The start_of_week parameter is optional. | DATENAME( month , #200404-15#) = "April" |
| DAY (date) | Returns the day of the given date as an integer. | DAY(#2004-04-12#) = 12 |
| NOW( ) | Returns the current date and time. | NOW( ) = 2004-04-15 1:08:21 PM |
Logical Functions
These functions evaluate some single value or the result of an expression and produce a boolean output.
| Function | Description | Example |
|---|---|---|
| IFNULL (expression1, expression2) | The IFNULL function returns the first expression if the result is not null, and returns the second expression if it is null. | IFNULL([Sales], 0) = [Sales] |
| ISDATE (string) | The ISDATE function returns TRUE if the string argument can be converted to a date, and FALSE if it cannot. | ISDATE("11/05/98") = TRUE ISDATE("14/05/98") = FALSE |
| MIN(expression) | The MIN function returns the minimum of an expression across all records or the minimum of two expressions for each record. | |
Aggregate Functions
| Function | Description | Example |
|---|---|---|
| AVG(expression) | Returns the average of all the values in the expression. AVG can be used with numeric fields only. Null values are ignored. | |
| COUNT (expression) | Returns the number of items in a group. Null values are not counted. | |
| MEDIAN (expression) | Returns the median of an expression across all records. Median can only be used with numeric fields. Null values are ignored. | |
| STDEV (expression) | Returns the statistical standard deviation of all values in the given expression based on a sample of the population. |