Tableau Table Calculations 3

Question 1

What does the SIZE() function return in a Tableau table calculation?

Accepted Answer

The number of rows in the current partition

Answer

The total number of marks in the entire view

Answer

The storage size of the data source in bytes

Answer

The number of columns on the Columns shelf

Question 2

How does LAST() differ from FIRST() in Tableau table calculations?

Accepted Answer

LAST() returns the offset to the last row of the partition; FIRST() returns the offset to the first row

Answer

LAST() returns the maximum value; FIRST() returns the minimum value

Answer

LAST() works only on date fields; FIRST() works on any type

Answer

They return the same offset value but with opposite signs

Question 3

How do you customize the formula of a Quick Table Calculation after applying it in Tableau?

Accepted Answer

Right-click the field and select 'Edit Table Calculation'

Answer

Use the Edit Filter dialog

Answer

Edit the formula in the Data Source page

Answer

Drag the field to the Analytics pane

Question 4

What is a nested table calculation in Tableau?

Accepted Answer

A table calculation that uses another table calculation as its input expression

Answer

A table calculation embedded inside a dashboard filter

Answer

A calculation that references multiple data sources simultaneously

Answer

A table calculation applied to a field inside a hierarchy

Question 5

At what point in Tableau's order of operations are table calculations computed?

Accepted Answer

After filters are applied, using only the remaining filtered data

Answer

Before dimension filters are applied

Answer

Simultaneously with context filters

Answer

Before aggregation of measures

Question 6

Which of the following is NOT a valid Tableau table calculation function?

Accepted Answer

CUMULATIVE()

Answer

INDEX()

Answer

RUNNING_AVG()

Answer

WINDOW_MAX()

Question 7

What is the primary use of the INDEX() table calculation function in Tableau?

Accepted Answer

To return the sequential row number of each row within the partition

Answer

To count distinct values within a partition

Answer

To identify the sorted position of a value in a list

Answer

To generate unique record IDs from the data source