Mastering Tableau 2018.1, Second Edition 7.1: Working with Table Calculations

The video tutorial covers different types of calculations in Tableau, including basic calculations, level of detail (LOD) expressions, and table calculations. It explains how basic and LOD calculations are performed at the data source level, while table calculations are computed at runtime. The tutorial also demonstrates creating custom calculations and using quick table calculations for comparative analysis. The video emphasizes the flexibility and power of Tableau's calculation functions, providing a foundation for further exploration in subsequent videos.

What are the three types of calculations available in Tableau?

• Basic calculations, quick table calculations, and data source calculations

• Quick table calculations, data source calculations, and runtime calculations

• Basic calculations, calculated field functions, and level of detail calculations

• Calculated field functions, runtime calculations, and data source calculations

How are table calculation functions different from other types of calculations in Tableau?

• They are only available in the latest version of Tableau

• They require manual input for each calculation

• They are performed at runtime and independent of the data source

• They are calculated at the data source level

What is the main purpose of using a calculated field in Tableau?

• To visualize data in a different format

• To create a new data source

• To perform calculations at runtime

• To write custom calculations and create new columns in the data source

In the example provided, how is the 110% sales value calculated?

• By subtracting 10% from the original sales value

• By dividing the sales value by 1.1

• By multiplying the sales value by 1.1

• By adding 10% to the original sales value

What is a quick table calculation in Tableau used for?

• To perform complex data source calculations

• To create new data sources

• To perform on-the-fly calculations on the canvas level

• To visualize data in a pie chart

Which of the following is an example of a quick table calculation?

• Performing a data source join

• Writing a custom script

• Calculating a running total

• Creating a new data source

What is the advantage of using quick table calculations in Tableau?

• They are easier to understand than other calculations

• They require less computational power

• They enable on-the-fly calculations without altering the data source

• They allow for permanent changes to the data source