Creating calculated fields in Tableau - Quick Revision & Summary

Recall & Review

beginner

What is a calculated field in Tableau?

A calculated field is a new field created by using a formula to combine or transform existing data fields. It helps you analyze data in ways not directly available in your original data.

beginner

How do you create a calculated field in Tableau?

Right-click in the Data pane and select 'Create Calculated Field'. Then enter your formula in the dialog box and click OK to add it to your data.

intermediate

Which of these is a valid Tableau calculated field formula?<br>

SUM([Sales]) / COUNT([Orders])

This formula calculates the average sales per order by dividing the total sales by the number of orders. It is valid because it uses aggregation functions correctly.

beginner

What happens if you use a calculated field with an error in Tableau?

Tableau shows an error message and does not create the field. You need to fix the formula syntax or logic before it can be used.

beginner

Why use calculated fields instead of changing the original data?

Calculated fields let you create new insights without changing the original data source. This keeps data safe and lets you experiment with different analyses easily.

What is the first step to create a calculated field in Tableau?

A Right-click in the Data pane and select 'Create Calculated Field'

B Edit the original data source

C Drag a field to the Rows shelf

D Click 'Show Me' and select a chart

You start by right-clicking in the Data pane and choosing 'Create Calculated Field' to open the formula editor.

Which of these is a valid aggregation function in Tableau calculated fields?

A MULTIPLY()

B ADD()

C SUM()

D DIVIDE()

SUM() is a valid aggregation function. ADD(), MULTIPLY(), and DIVIDE() are not Tableau functions.

What does this calculated field do? <br>

IF [Profit] > 0 THEN 'Good' ELSE 'Bad' END

A Calculates total profit

B Labels profits as 'Good' if positive, otherwise 'Bad'

C Filters out negative profits

D Creates a sum of profits

This formula checks if Profit is positive and labels it 'Good', otherwise 'Bad'.

If a calculated field formula has a syntax error, what will Tableau do?

A Show an error and prevent creation

B Create the field anyway

C Ignore the error and use default values

D Automatically fix the error

Tableau shows an error message and stops you from creating the field until the error is fixed.

Why is it better to use calculated fields instead of changing the original data?

A Calculated fields automatically clean data

B Calculated fields run faster than original data

C Original data cannot be edited in Tableau

D Keeps original data safe and allows flexible analysis

Calculated fields let you create new insights without altering the original data, keeping it safe and flexible.

Explain how to create a calculated field in Tableau and give an example formula.

Think about the steps you take in Tableau to add new data calculations.

Describe why calculated fields are useful and how they differ from changing the original data.

Consider the benefits of keeping original data intact.