Tableau Table Calculations

Question 1

What is a table calculation in Tableau?

Accepted Answer

A computation applied to the values already in the visualization

Answer

A calculation executed at the database level before results return

Answer

A fixed value expression that ignores filters

Answer

A calculation that only works on date fields

Question 2

Which of the following is a built-in Quick Table Calculation available in Tableau?

Accepted Answer

Running Total

Answer

FIXED

Answer

INCLUDE

Answer

COUNTD

Question 3

What does the 'Compute Using' option in a Tableau table calculation control?

Accepted Answer

The direction and scope across which the calculation traverses

Answer

The aggregation formula applied to the measure

Answer

The data source queried for the calculation

Answer

The level of detail applied to dimensions

Question 4

Which Tableau function calculates a cumulative sum from the first row to the current row?

Accepted Answer

RUNNING_SUM()

Answer

SUM()

Answer

TOTAL()

Answer

WINDOW_SUM()

Question 5

How does WINDOW_SUM() differ from RUNNING_SUM() in Tableau?

Accepted Answer

WINDOW_SUM() totals all values in the partition; RUNNING_SUM() accumulates from start to current row

Answer

WINDOW_SUM() only works on measures; RUNNING_SUM() works on dimensions too

Answer

WINDOW_SUM() requires a date field; RUNNING_SUM() does not

Answer

They are identical functions with different names

Question 6

What does the RANK() function in Tableau assign to tied values?

Accepted Answer

The same rank with subsequent positions skipped (e.g., 1, 1, 3)

Answer

Sequential unique ranks with no skipping

Answer

The average of their position numbers

Answer

The last rank within their tied group

Question 7

Which Tableau function returns the value from a previous row in the current partition?

Accepted Answer

LOOKUP(SUM([Sales]), -1)

Answer

PREVIOUS_VALUE()

Answer

LAG()

Answer

OFFSET(-1)