Practice Test GeeksTableau Practice Test
← All Tableau Flashcard Decks

Calculations and Parameters 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 Calculations and Parameters flashcards as text

  1. Which LOD expression ignores the dimensions in the view entirely except those specified?

    Answer: FIXED

    FIXED computes using only the specified dimensions, ignoring all others in the view.

  2. What is the result of the expression INT(3.99) in Tableau?

    Answer: 3

    INT() truncates toward zero, so 3.99 becomes 3.

  3. Which function returns the rank of a value, leaving gaps after ties?

    Answer: RANK()

    RANK() assigns the same rank to ties and skips subsequent numbers, leaving gaps.

  4. How can a parameter dynamically swap which measure is shown on an axis?

    Answer: Use a CASE statement referencing the parameter

    A CASE or IF calculated field reads the parameter and returns the chosen measure.

  5. Which string function returns the number of characters in a field?

    Answer: LEN()

    LEN() returns the length of a string as an integer.

  6. What does WINDOW_AVG(SUM([Sales])) compute by default?

    Answer: Average of summed sales across the partition

    WINDOW_AVG averages the aggregated values across the entire window/partition.

  7. Which function tests whether a value is null?

    Answer: ISNULL()

    ISNULL() returns true when the expression is null.