Tableau Calculations and Parameters 2

Question 1

Which function returns the running total of a measure across the addressing dimension?

Accepted Answer

RUNNING_SUM()

Answer

RUNNING_SUM() computes a cumulative total from the first row to the current row along the partition.

Question 2

What type of calculation is computed by Tableau's data engine before aggregation, on a row level?

Accepted Answer

Row-level calculation

Answer

Row-level calculations evaluate for every individual record in the underlying data before aggregation.

Question 3

Which LOD expression computes a value at a more granular level than the view?

Accepted Answer

INCLUDE

Answer

INCLUDE LOD expressions add dimensions, increasing granularity beyond what is in the view.

Question 4

A parameter in Tableau can hold how many values at a single point in time?

Accepted Answer

One single value

Answer

A parameter is a single dynamic value that the user sets one at a time.

Question 5

Which function would you use to extract the year from a date field?

Accepted Answer

DATEPART('year', [Date])

Answer

DATEPART('year', [Date]) returns the year as an integer.

Tableau Practice Test