Tableau Table Calculations 3

Question 1

What does the SIZE() function return in a Tableau table calculation?

Accepted Answer

The number of rows in the current partition

Answer

SIZE() returns the count of rows in the current partition, useful for calculations that need to know the total number of items in a group.

Question 2

How does LAST() differ from FIRST() in Tableau table calculations?

Accepted Answer

LAST() returns the offset to the last row of the partition; FIRST() returns the offset to the first row

Answer

LAST() returns the distance from the current row to the last row in the partition (zero at the last row, positive before it), while FIRST() measures distance to the first row.

Question 3

How do you customize the formula of a Quick Table Calculation after applying it in Tableau?

Accepted Answer

Right-click the field and select 'Edit Table Calculation'

Answer

Right-clicking a measure pill that has a Quick Table Calculation applied and selecting 'Edit Table Calculation' opens the dialog where you can modify the calculation's settings and formula.

Question 4

What is a nested table calculation in Tableau?

Accepted Answer

A table calculation that uses another table calculation as its input expression

Answer

A nested table calculation feeds one table calculation's output as the input to another, such as ranking a running sum by wrapping RUNNING_SUM() inside RANK().

Question 5

At what point in Tableau's order of operations are table calculations computed?

Accepted Answer

After filters are applied, using only the remaining filtered data

Answer

Table calculations are applied after all filtering and aggregation steps, so they operate on the filtered, aggregated result set that appears in the view.

Tableau Practice Test

Tableau Practice Test

Tableau Table Calculations 3