Practice Test GeeksTCC - Tableau Certified Consultant Practice Test
← All TCC Flashcard Decks

Calculations and Expressions Flashcards

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

Read the first 7 Calculations and Expressions flashcards as text

  1. What is the primary purpose of the TOTAL() function within a Tableau table calculation?

    Answer: It returns the sum of values across the entire current partition of a table calculation

    TOTAL() returns an aggregate (defaulting to SUM) of the expression across the entire current partition, making it useful for computing percentages of total within each partition.

  2. What is the most effective way for a Tableau consultant to reuse calculated fields consistently across multiple workbooks connecting to the same data?

    Answer: Embed the calculations in a published data source on Tableau Server or Cloud

    Embedding calculations in a published data source ensures that any workbook connecting to that source automatically inherits the calculations, enforcing consistency and a single source of truth.

  3. When should a Tableau developer use a FIXED LOD expression instead of a standard aggregate measure in the view?

    Answer: When the required aggregation granularity is coarser than the current view's level of detail

    FIXED LOD expressions are the right tool when you need to aggregate at a higher (coarser) granularity than what the view displays, such as computing a per-customer average while the view shows individual orders.

  4. Which Tableau calculation construct is best suited for evaluating a single dimension field against multiple specific discrete values and returning a corresponding result for each?

    Answer: CASE / WHEN / THEN / END

    CASE/WHEN is optimized for matching a single expression against a list of specific values, producing cleaner and more readable syntax than nested IF/ELSEIF chains for this pattern.

  5. What happens when a Tableau LOD expression is nested inside another LOD expression?

    Answer: The inner LOD is resolved first, and its result is available as input to the outer LOD

    Tableau supports nested LOD expressions; the inner expression is evaluated at its declared granularity first, and the resulting value is then used within the outer LOD expression's computation.

  6. In Tableau's Quick Table Calculations, which calculation shows how much each value differs from the value of the preceding mark in the addressing direction?

    Answer: Difference From

    The 'Difference From' quick table calculation subtracts a reference value (such as the previous mark) from the current value, showing absolute change between sequential data points.

  7. What does the Tableau ATTR() aggregation function return when the underlying data contains multiple different values for the field within the current view's level of detail?

    Answer: An asterisk (*) indicating that the field is not uniquely defined at this granularity

    ATTR() returns the field's value only when every row in the partition shares the same value; if there are multiple distinct values, it returns '*' to signal the ambiguity.