Tableau Table Calculations 2

Question 1

What does FIRST() return in a Tableau table calculation?

Accepted Answer

The number of rows from the current row to the first row of the partition

Answer

FIRST() returns the offset (distance) from the current row to the first row in the partition, which is zero at the first row and negative for all others.

Question 2

In Tableau table calculations, what does the term 'partition' refer to?

Accepted Answer

The subset of data within which the table calculation restarts

Answer

A partition defines the scope within which a table calculation resets and computes independently, while addressing defines the direction the calculation moves within that partition.

Question 3

What role do 'Addressing' fields play in a Tableau table calculation?

Accepted Answer

They define the direction the calculation traverses within each partition

Answer

Addressing fields specify the direction (across rows, down columns, etc.) the table calculation moves when computing values within each partition.

Question 4

Which formula correctly calculates percent of total using a table calculation in Tableau?

Accepted Answer

SUM([Sales]) / TOTAL(SUM([Sales]))

Answer

Percent of total divides the current value by TOTAL(), which returns the grand total across the partition, giving each row's share as a decimal.

Question 5

What does WINDOW_AVG() compute in Tableau?

Accepted Answer

The average of an expression over a specified window of rows within the partition

Answer

WINDOW_AVG(expression, [start, end]) computes the average of the expression across a defined range of rows within the current partition.

Tableau Practice Test

Tableau Practice Test

Tableau Table Calculations 2