Create IF THEN expressions - Tableau Tutorial

Contents

• Introduction Introduction

  • Welcome

    1m 14s
  • What you need to know

    58s
  • Using the exercise files

    35s
• 1. Introducing Calculations in Tableau 10 1. Introducing Calculations in Tableau 10

  • Define data types and conversions

    2m 28s
  • Define function syntax in Tableau 10

    3m 2s
  • Create calculations using arithmetic operators

    2m 51s
  • Use logical and comparison operators in calculations

    4m 23s
  • Create a calculated field

    4m 37s
  • Create an ad hoc calculation

    4m 15s
• 2. Summarizing Data Using Aggregate Functions 2. Summarizing Data Using Aggregate Functions

  • Calculate the sum of a collection of values

    2m 33s
  • Calculate the average, median, minimum, and maximum of a set of values

    7m 5s
  • Identify the percentile of a given value

    6m 7s
  • Find the variance and standard deviation of populations and samples

    6m 54s
  • Count all values or distinct values in a data set

    3m 52s
  • Find the value of an attribute

    1m 45s
• 3. Calculating Values Using Number Functions 3. Calculating Values Using Number Functions

  • Find the absolute value or sign of a number

    4m 38s
  • Round numbers up or down

    6m 26s
  • Find the integer and decimal components of a division operation

    4m 25s
  • Calculate the square or square root of a value

    3m 36s
  • Identify the larger or smaller of two values

    3m 38s
  • Return zero if a calculation includes a null value

    3m 21s
• 4. Working with Times and Dates 4. Working with Times and Dates

  • Return the current date or date and time

    4m 7s
  • Return the day, month, or year component of a date

    4m 50s
  • Identify part of a date using DATEPART

    5m 3s
  • Add or subtract intervals from dates

    6m 37s
  • Truncate a date

    3m 37s
  • Identify the earlier or later of two dates

    3m 18s
• 5. Creating Conditional Calculations Using Logical Functions 5. Creating Conditional Calculations Using Logical Functions

  • Create IF THEN expressions

    4m 12s
  • Create IF THEN ELSE and ELSE IF expressions

    3m 5s
  • Return true or false values using IIF

    6m 7s
  • Define multilevel conditions using CASE expressions

    4m 45s
  • Manage null values using IFNULL and ISNULL

    4m 41s
• 6. Creating Level of Detail (LOD) Expressions 6. Creating Level of Detail (LOD) Expressions

  • Create a level of detail (LOD) expression

    3m 15s
  • Create level of detail expressions using FIXED

    4m 4s
  • Create level of detail expressions using INCLUDE

    3m 42s
  • Create level of detail expressions using EXCLUDE

    4m 14s
• 7. Summarizing Data Using Table Calculations 7. Summarizing Data Using Table Calculations

  • Create a quick table calculation

    3m 46s
  • Calculate a running total or moving average

    6m 5s
  • Add a secondary table calculation

    4m 25s
  • Rank table data

    3m 54s
  • Identify a table row using INDEX

    2m 3s
  • Count table rows from first or last row

    3m 40s
  • Look up values using PREVIOUS_VALUE and LOOKUP

    5m 43s
  • Return the number of rows in the partition

    3m 50s
  • Summarize data within a defined window of rows

    5m 49s
• 8. Managing Text Strings 8. Managing Text Strings

  • Convert and measure strings

    4m 32s
  • Find and replace text in a string

    4m 31s
  • Trim and pad strings

    1m 28s
  • Determine if a sequence occurs within a string

    4m 5s
  • Return characters from part of a string

    5m 31s
• Conclusion Conclusion

  • Next steps

    57s