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

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

Question 2

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

Accepted Answer

Running Total

Answer

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.

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

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

Question 4

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

Accepted Answer

RUNNING_SUM()

Answer

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

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() 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.

Tableau Practice Test

Tableau Practice Test

Tableau Table Calculations