Обчислювані поля

Вступ до 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
Вступ до 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")
Вступ до 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...
Вступ до 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
Вступ до 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
Вступ до Tableau

Dataset

Mean Years in School

Вступ до Tableau

Let's practice!

Вступ до Tableau

Preparing Video For Download...