pbPassingBI
/
tableau/quizzes/tableau-calculations-quiz
advanced 10 questions

Calculations Quiz

Calculated fields, aggregation and table calculations.

  1. Which correctly computes overall profit ratio?

    1. AVG([Profit]/[Sales])
    2. SUM([Profit])/SUM([Sales])
    3. SUM([Profit]/[Sales])
    4. [Profit]/[Sales]

    Answer: SUM([Profit])/SUM([Sales]) — Divide the totals; averaging per-row ratios weights small rows equally with large ones.

  2. Why does SUM([Sales]) - [Cost] error?

    1. Cost is null
    2. It mixes aggregate and non-aggregate arguments
    3. SUM cannot subtract
    4. Cost is a dimension

    Answer: It mixes aggregate and non-aggregate arguments — One side is one value per group, the other one value per row.

  3. Aggregation in Tableau means:

    1. Splitting rows apart
    2. Viewing measures at higher, summarised levels
    3. Filtering data
    4. Sorting values

    Answer: Viewing measures at higher, summarised levels — Placing a measure on a shelf aggregates it, usually by summing.

  4. Disaggregating the data lets you:

    1. Publish faster
    2. View every row of the data source
    3. Remove filters
    4. Create sets

    Answer: View every row of the data source — Useful when analysing a measure both independently and dependently in the view.

  5. Table calculations are computed:

    1. At the data source
    2. On the aggregated result already in the view
    3. At extract refresh
    4. On publish

    Answer: On the aggregated result already in the view — They run after the query, which is why they can only see what the view contains.

  6. Which function converts null to zero?

    1. IFNULL()
    2. ZN()
    3. ISNULL()
    4. NULLIF()

    Answer: ZN() — ZN() returns zero for a null expression, preventing gaps and broken arithmetic.

  7. CASE is generally preferred over a long IF/ELSEIF chain because:

    1. It allows ranges
    2. It is cleaner and generally performs better for discrete matches
    3. It handles nulls
    4. It is required for strings

    Answer: It is cleaner and generally performs better for discrete matches — Use CASE when matching one field against discrete values; IF for ranges and complex conditions.

  8. Which is faster in a calculation?

    1. String operations
    2. Numeric and boolean operations
    3. They are identical
    4. Date parsing

    Answer: Numeric and boolean operations — Numeric and boolean calculations evaluate considerably faster than string ones.

  9. To use a group inside a calculation you must:

    1. Use an ad-hoc group
    2. Create the group as a field and reference it
    3. Publish the workbook
    4. Convert it to a set

    Answer: Create the group as a field and reference it — Ad-hoc groups cannot be referenced in a calculation; create the grouping field first.

  10. WINDOW_AVG(SUM([Sales]), -2, 0) produces:

    1. A grand total
    2. A three-period moving average
    3. A running total
    4. A rank

    Answer: A three-period moving average — It averages the current row and the two preceding it.