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 function returns the absolute value of a number?

    Answer: ABS()

    ABS() returns the non-negative magnitude of a number.

  2. What does PREVIOUS_VALUE(0) typically help build?

    Answer: A custom running calculation

    PREVIOUS_VALUE returns the value of the prior row, enabling custom cumulative table calculations.

  3. Which LOD expression removes a dimension that is present in the view from the calculation?

    Answer: EXCLUDE

    EXCLUDE LOD expressions omit specified dimensions from the level of detail.

  4. What data type must a parameter used in a TOP N filter typically be?

    Answer: Integer

    A Top N parameter holds an integer count of how many items to display.

  5. Which function returns the position of a substring within a string?

    Answer: FIND()

    FIND() returns the index position where a substring begins, or 0 if not found.

  6. What does the LOOKUP(SUM([Sales]), -1) function return?

    Answer: The sum of sales from the previous mark

    LOOKUP with an offset of -1 returns the value from the previous row in the partition.

  7. Which is true about aggregate and non-aggregate fields in a single calculation?

    Answer: They cannot be mixed directly

    Tableau does not allow mixing aggregate and non-aggregate arguments in the same expression.