Table Calculations Flashcards

What is a table calculation in Tableau?

Answer: A computation applied to the values already in the visualization

Table calculations are computations performed on the values returned by the query and displayed in the visualization, not at the database level.

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

Answer: Running Total

Running Total is one of Tableau's built-in Quick Table Calculations; FIXED and INCLUDE are LOD expression keywords, and COUNTD is an aggregation function.

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

Answer: The direction and scope across which the calculation traverses

'Compute Using' determines which dimensions the table calculation moves across (addresses) and which it restarts across (partitions).

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

Answer: RUNNING_SUM()

RUNNING_SUM() accumulates the sum from the first row of the partition to the current row, making it ideal for running totals.

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

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

WINDOW_SUM() returns the same total for every row (the sum across the entire partition window), while RUNNING_SUM() grows incrementally from the first row to the current row.

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

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

RANK() uses competition ranking: tied values share the same lowest rank, and the next rank is skipped accordingly (e.g., two items tied for 1st both get 1, next item gets 3).

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

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

LOOKUP(expression, offset) retrieves the value from a row at a given offset; using -1 accesses the immediately preceding row in the partition.