Calculated fields

Introduction to Tableau

Lis Sulmont

Content Program Manager at Duolingo

What are calculated fields?

Calculated fields allow you to create new data from data that already exists in your data source.$^1$

1 https://help.tableau.com/current/pro/desktop/en-us/calculations_calculatedfields_create.htm
Introduction to Tableau

Examples of calculated fields

  • With sales_amount_usd
    • Calculated field sales_amount_euro = sales_amount_usd * 0.90
  • With gas_prices
    • Calculated field gas_prices_rounded_up = CEILING(gas_prices)
  • With emails
    • Calculated field gmail_emails = ENDSWITH(emails, "@gmail.com")
Introduction to Tableau

Examples of calculated fields

  • With date
    • Calculated field year = YEAR(date)
  • With price and earnings
    • Calculated field price_earnings_ratio = prices / earnings
  • And much more...
Introduction to Tableau

What are calculated fields?

Calculated fields allow you to create new data from data that already exists in your data source.$^1$

  • Creates a new column
  • Underlying data is unaffected

 

 

1 https://help.tableau.com/current/pro/desktop/en-us/calculations_calculatedfields_create.htm
Introduction to Tableau

Functions

Examples: CEILING(), ENDSWITH(), DIV()

  1. Number functions
  2. String functions
  3. Date functions
  4. Type conversions
  5. Logical functions

... and more!$^1$

1 https://help.tableau.com/current/pro/desktop/en-us/functions.htm
Introduction to Tableau

Dataset

Mean Years in School

Introduction to Tableau

Let's practice!

Introduction to Tableau

Preparing Video For Download...