Practice Test Geeks(TCC) Texas Counselor Certification 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. Which type of Tableau expression computes a result at a specified dimension level regardless of the filters applied to the current view?

    Answer: FIXED LOD expression

    FIXED LOD expressions compute at the declared dimension level and are evaluated before dimension filters, making them independent of view-level filter context.

  2. What is the correct Tableau syntax for a FIXED Level of Detail expression that calculates average profit per region?

    Answer: {FIXED [Region] : AVG([Profit])}

    FIXED LOD expressions use curly braces with the keyword FIXED, followed by the dimension declaration, a colon, and the aggregate expression.

  3. Which type of Tableau calculation is executed by the Tableau engine after data has been retrieved from the data source, rather than being pushed to the database?

    Answer: Table calculations

    Table calculations are computed by Tableau's query engine on the aggregated result set already returned from the data source, not at the database level.

  4. What does the Tableau LOOKUP() table calculation function return?

    Answer: The value of an expression in a target row offset relative to the current row

    LOOKUP() returns the value of a given expression at a row that is a specified number of positions before or after the current row in the table calculation's addressing direction.

  5. Which LOD expression type adds a dimension to the view's level of detail for the purpose of a finer-grained computation?

    Answer: INCLUDE

    INCLUDE LOD expressions add the specified dimension to whatever granularity is in the view, resulting in a finer aggregation that is then re-aggregated at the view level.

  6. How does a FIXED LOD expression interact with a standard dimension filter in Tableau's order of operations?

    Answer: FIXED LOD runs before dimension filters are applied

    In Tableau's order of operations, FIXED LOD expressions are evaluated before dimension filters, so they compute on unfiltered data unless the filtered dimension is promoted to a context filter.

  7. Which of the following is the most appropriate use case for an EXCLUDE LOD expression in Tableau?

    Answer: Calculating a percent of total that removes a specific dimension from the computation

    EXCLUDE LOD expressions remove a specified dimension from the view's level of detail, which is ideal for computing aggregates like percent of total that should ignore one dimension.