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

The first value in the partition

Answer

The index of the first row (always 1)

Answer

The minimum value within the partition

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 filter applied before the query runs

Answer

A group of measures computed together

Answer

A dimension added to the Rows shelf

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

They filter which records are included in the calculation

Answer

They set the granularity for measure aggregation

Answer

They determine which measures are visible in the view

Question 4

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

Accepted Answer

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

Answer

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

Answer

PERCENT(SUM([Sales]))

Answer

SUM([Sales]) / RUNNING_SUM(SUM([Sales]))

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

The average of all measures across the entire workbook

Answer

A moving average updated automatically with new data

Answer

The average value excluding null rows only

Question 6

When using LOOKUP() in Tableau, which offset value references a future (upcoming) row?

Accepted Answer

A positive value

Answer

A negative value

Answer

Zero

Answer

NULL

Question 7

Which Quick Table Calculation shows the absolute change between consecutive period values?

Accepted Answer

Difference

Answer

Running Total

Answer

Percent of Total

Answer

Rank