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 the SIZE() function return in a Tableau table calculation?

    Answer: The number of rows in the current partition

    SIZE() returns the count of rows in the current partition, useful for calculations that need to know the total number of items in a group.

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

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

    LAST() returns the distance from the current row to the last row in the partition (zero at the last row, positive before it), while FIRST() measures distance to the first row.

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

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

    Right-clicking a measure pill that has a Quick Table Calculation applied and selecting 'Edit Table Calculation' opens the dialog where you can modify the calculation's settings and formula.

  4. What is a nested table calculation in Tableau?

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

    A nested table calculation feeds one table calculation's output as the input to another, such as ranking a running sum by wrapping RUNNING_SUM() inside RANK().

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

    Answer: After filters are applied, using only the remaining filtered data

    Table calculations are applied after all filtering and aggregation steps, so they operate on the filtered, aggregated result set that appears in the view.

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

    Answer: CUMULATIVE()

    CUMULATIVE() does not exist in Tableau; use RUNNING_SUM() to achieve cumulative totals. INDEX(), RUNNING_AVG(), and WINDOW_MAX() are all valid Tableau functions.

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

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

    INDEX() returns the sequential position (1, 2, 3, …) of each row within its partition, making it useful for creating numbered lists, custom ranks, or controlling which rows display.