Practice Test GeeksTableau Practice Test
← All Tableau Flashcard Decks

Table Calculations Flashcards

7 cards from real Tableau practice questions. Tap to flip, then mark Knew It or Still Learning — missed cards come back until you master them.

Read the first 7 Table Calculations flashcards as text

  1. What does FIRST() return in a Tableau table calculation?

    Answer: The number of rows from the current row to the first row of the partition

    FIRST() returns the offset (distance) from the current row to the first row in the partition, which is zero at the first row and negative for all others.

  2. In Tableau table calculations, what does the term 'partition' refer to?

    Answer: The subset of data within which the table calculation restarts

    A partition defines the scope within which a table calculation resets and computes independently, while addressing defines the direction the calculation moves within that partition.

  3. What role do 'Addressing' fields play in a Tableau table calculation?

    Answer: They define the direction the calculation traverses within each partition

    Addressing fields specify the direction (across rows, down columns, etc.) the table calculation moves when computing values within each partition.

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

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

    Percent of total divides the current value by TOTAL(), which returns the grand total across the partition, giving each row's share as a decimal.

  5. What does WINDOW_AVG() compute in Tableau?

    Answer: The average of an expression over a specified window of rows within the partition

    WINDOW_AVG(expression, [start, end]) computes the average of the expression across a defined range of rows within the current partition.

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

    Answer: A positive value

    A positive offset in LOOKUP() looks ahead to future rows (e.g., LOOKUP(SUM([Sales]), 1) returns the next row's value), while negative offsets look back.

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

    Answer: Difference

    The 'Difference' Quick Table Calculation subtracts the previous period's value from the current value, showing period-over-period absolute change.