Tableau Calculations and Parameters 3

Question 1

Which LOD expression ignores the dimensions in the view entirely except those specified?

Accepted Answer

FIXED

Answer

FIXED computes using only the specified dimensions, ignoring all others in the view.

Question 2

What is the result of the expression INT(3.99) in Tableau?

Accepted Answer

3

Answer

INT() truncates toward zero, so 3.99 becomes 3.

Question 3

Which function returns the rank of a value, leaving gaps after ties?

Accepted Answer

RANK()

Answer

RANK() assigns the same rank to ties and skips subsequent numbers, leaving gaps.

Question 4

How can a parameter dynamically swap which measure is shown on an axis?

Accepted Answer

Use a CASE statement referencing the parameter

Answer

A CASE or IF calculated field reads the parameter and returns the chosen measure.

Question 5

Which string function returns the number of characters in a field?

Accepted Answer

LEN()

Answer

LEN() returns the length of a string as an integer.

Tableau Practice Test