Share Description
In this course, you will :
- Learn how to use this feature of the platform to create useful and powerful formulas in Tableau Desktop.
- begins with a discussion of data types, conversions, and function syntax before demonstrating how to create a calculated field and an ad hoc calculation.
- explains how to use aggregate functions to summarise data, including how to calculate the sum of a set of values as well as the average, minimum, and maximum of a set.
- Working with times and dates, creating conditional calculations, implementing level of detail expressions, and other topics are covered.
Syllabus :
1. Introducing Calculations in Tableau 10
- Define data types and conversions
- Define function syntax in Tableau 10
- Create calculations using arithmetic operators
- Use logical and comparison operators in calculations
- Create a calculated field
- Create an ad hoc calculation
2. Summarizing Data Using Aggregate Functions
- Calculate the sum of a collection of values
- Calculate the average, median, minimum, and maximum of a set of values
- Identify the percentile of a given value
- Find the variance and standard deviation of populations and samples
- Count all values or distinct values in a data set
- Find the value of an attribute
3. Calculating Values Using Number Functions
- Find the absolute value or sign of a number
- Round numbers up or down
- Find the integer and decimal components of a division operation
- Calculate the square or square root of a value
- Identify the larger or smaller of two values
- Return zero if a calculation includes a null value
4. Working with Times and Dates
- Return the current date or date and time
- Return the day, month, or year component of a date
- Identify part of a date using DATEPART
- Add or subtract intervals from dates
- Truncate a date
- Identify the earlier or later of two dates
5. Creating Conditional Calculations Using Logical Functions
- Create IF THEN expressions
- Create IF THEN ELSE and ELSE IF expressions
- Return true or false values using IIF
- Define multilevel conditions using CASE expressions
- Manage null values using IFNULL and ISNULL
6. Creating Level of Detail (LOD) Expressions
- Create a level of detail (LOD) expression
- Create level of detail expressions using FIXED
- Create level of detail expressions using INCLUDE
- Create level of detail expressions using EXCLUDE
7. Summarizing Data Using Table Calculations
- Create a quick table calculation
- Calculate a running total or moving average
- Add a secondary table calculation
- Rank table data
- Identify a table row using INDEX
- Count table rows from first or last row
- Look up values using PREVIOUS_VALUE and LOOKUP
- Return the number of rows in the partition
- Summarize data within a defined window of rows
8. Managing Text Strings
- Convert and measure strings
- Find and replace text in a string
- Trim and pad strings
- Determine if a sequence occurs within a string
- Return characters from part of a string
