AnalystReps

Tableau practice: Table calculation direction and addressing

Chapter 18 · 5 questions · included in full access

  1. Question 1 · easy

    Addressing versus partitioning dimensions

    In Tableau table calculations, what role does an addressing dimension (Compute Using) play?

    Solve it in your browser

  2. Question 2 · hard

    Year over year growth

    Create YoY Growth: sales compared with the same month last year, computed along Year: (SUM([Sales]) - LOOKUP(SUM([Sales]), -1)) / ABS(LOOKUP(SUM([Sales]), -1)).

    Solve it in your browser

  3. Question 3 · easy

    Table across versus Table down

    In a cross-tab with Region on Rows and Segment on Columns, what does Table (Across) compute for percentage of total?

    Solve it in your browser

  4. Question 4 · medium

    Regional segment matrix view

    Build a cross-tab view with Region on Rows, Segment on Columns, and SUM(Sales) on Columns.

    Solve it in your browser

  5. Question 5 · hard

    Rank within partition

    Create Rep Rank Partitioned: rank reps by total sales using RANK(SUM([Sales])).

    Solve it in your browser

These questions are part of full access.

The first chapters of every track are free. Full access is a one-time payment.

See pricing