Bird
Raised Fist0
Tableaubi_tool~5 mins

Date hierarchy (year, quarter, month, day) in Tableau - Cheat Sheet & Quick Revision

Choose your learning style10 modes available
LearnWhyDeepSheetTryChallengeScenarioRecallDash

Start learning this pattern below

Jump into concepts and practice - no test required

or
Recommended
Test this pattern10 questions across easy, medium, and hard to know if this pattern is strong
Recall & Review
beginner
What is a date hierarchy in Tableau?
A date hierarchy in Tableau is a way to organize date fields into levels like year, quarter, month, and day. It helps you drill down or roll up time data easily in your visualizations.
Click to reveal answer
beginner
List the typical levels in a date hierarchy.
The typical levels are: Year → Quarter → Month → Day. This order lets you explore data from broad to detailed time periods.
Click to reveal answer
intermediate
How do you create a date hierarchy in Tableau?
Right-click a date field, select 'Create' → 'Hierarchy', then add Year, Quarter, Month, and Day fields to it. This groups them for easy drill-down in views.
Click to reveal answer
intermediate
Why use a date hierarchy instead of separate date fields?
A date hierarchy lets you drill down smoothly from year to day in one place. It keeps your view clean and helps spot trends over time easily.
Click to reveal answer
beginner
What happens when you double-click a date hierarchy in Tableau?
Tableau adds the highest level (usually Year) to the view. You can then expand levels to see quarters, months, and days step by step.
Click to reveal answer
Which level is NOT part of a standard date hierarchy in Tableau?
AQuarter
BYear
CWeekday
DMonth
How do you add a date hierarchy in Tableau?
ARight-click date field → Create → Hierarchy
BDouble-click the date field
CUse the Data Source tab to merge dates
DDrag and drop date fields into a new folder
What is the main benefit of using a date hierarchy?
AIt automatically formats dates as text
BIt removes duplicate dates
CIt creates calculated fields
DIt allows easy drill-down from year to day
When you expand a date hierarchy in Tableau, what happens?
AThe data is filtered by the selected date
BThe view shows more detailed time levels like months or days
CThe date field is removed
DThe data source refreshes
Which of these is the correct order of levels in a date hierarchy?
AYear → Quarter → Month → Day
BMonth → Quarter → Year → Day
CDay → Month → Quarter → Year
DQuarter → Year → Day → Month
Explain how a date hierarchy helps in analyzing time-based data in Tableau.
Think about how you explore data from big time chunks to small ones.
You got /4 concepts.
    Describe the steps to create a date hierarchy in Tableau and how to use it in a visualization.
    Focus on the menu options and interaction with the view.
    You got /5 concepts.

      Practice

      (1/5)
      1. What is the main purpose of a Date hierarchy in Tableau?
      easy
      A. To explore data by Year, Quarter, Month, and Day levels easily
      B. To create new calculated fields based on dates
      C. To filter data only by year
      D. To sort data alphabetically

      Solution

      1. Step 1: Understand what a date hierarchy does

        A date hierarchy organizes dates into levels like Year, Quarter, Month, and Day for easy exploration.

      2. Step 2: Compare options to this purpose

        Only To explore data by Year, Quarter, Month, and Day levels easily describes exploring data by these date levels. Others describe unrelated tasks.

      3. Final Answer:

        To explore data by Year, Quarter, Month, and Day levels easily -> Option A

      4. Quick Check:

        Date hierarchy = Explore by date levels [OK]
      Hint: Date hierarchy breaks dates into levels for easy drill-down [OK]
      Common Mistakes:
      • Thinking it only filters by year
      • Confusing with calculated fields
      • Assuming it sorts alphabetically
      2. Which of the following is the correct way to create a date hierarchy in Tableau?
      easy
      A. Write a SQL query to group dates by year
      B. Drag a date field to Rows, then right-click and select 'Create Hierarchy', adding Year, Quarter, Month, Day
      C. Use the filter pane to select Year, Quarter, Month, and Day separately
      D. Manually type dates in a new column

      Solution

      1. Step 1: Recall Tableau's method to create hierarchies

        In Tableau, you create hierarchies by dragging fields and grouping them, not by SQL or typing dates manually.

      2. Step 2: Identify the correct process

        Drag a date field to Rows, then right-click and select 'Create Hierarchy', adding Year, Quarter, Month, Day correctly describes dragging a date field and creating a hierarchy with Year, Quarter, Month, and Day.

      3. Final Answer:

        Drag a date field to Rows, then right-click and select 'Create Hierarchy', adding Year, Quarter, Month, Day -> Option B

      4. Quick Check:

        Create hierarchy by drag and right-click [OK]
      Hint: Right-click date field to create hierarchy in Tableau [OK]
      Common Mistakes:
      • Trying to create hierarchy via SQL
      • Using filters instead of hierarchy
      • Typing dates manually instead of using fields
      3. Given a date hierarchy with Year > Quarter > Month > Day, what happens when you double-click the Year field in Tableau's view?
      medium
      A. Tableau filters data to the current Year only
      B. Tableau drills down to show data by Day directly
      C. Tableau shows data aggregated by Year only
      D. Tableau shows data aggregated by Month only

      Solution

      1. Step 1: Understand double-click on a hierarchy level

        Double-clicking a level like Year shows data aggregated at that level, not deeper levels.

      2. Step 2: Match behavior to options

        Tableau shows data aggregated by Year only correctly states data is aggregated by Year only. Other options describe filtering or drilling down incorrectly.

      3. Final Answer:

        Tableau shows data aggregated by Year only -> Option C

      4. Quick Check:

        Double-click Year = aggregate by Year [OK]
      Hint: Double-click a level to see data summarized at that level [OK]
      Common Mistakes:
      • Thinking double-click drills down multiple levels
      • Confusing aggregation with filtering
      • Assuming it shows data by Month or Day immediately
      4. You created a date hierarchy but when you try to drill down from Year to Quarter, Tableau shows no data. What is the most likely cause?
      medium
      A. The Year field is not a date type
      B. The data source has no date values
      C. You forgot to refresh the data source
      D. The Quarter field is not included in the hierarchy

      Solution

      1. Step 1: Analyze why drill down shows no data

        If drilling from Year to Quarter shows no data, likely the Quarter level is missing in the hierarchy.

      2. Step 2: Evaluate other options

        Data source missing dates or Year not date type would cause bigger issues; refreshing data is less likely the cause.

      3. Final Answer:

        The Quarter field is not included in the hierarchy -> Option D

      4. Quick Check:

        Missing Quarter in hierarchy blocks drill down [OK]
      Hint: Check all date levels are in the hierarchy to drill down [OK]
      Common Mistakes:
      • Assuming data source is empty without checking
      • Forgetting to include all date parts in hierarchy
      • Thinking refresh fixes hierarchy structure
      5. You want to create a dashboard showing sales trends by Year, then allow users to drill down to Quarter, Month, and Day. Which approach best uses Tableau's date hierarchy feature?
      hard
      A. Create a date hierarchy with Year > Quarter > Month > Day and use it in the view with drill-down enabled
      B. Create separate sheets for Year, Quarter, Month, and Day and link them with filters
      C. Use only the Month field and filter manually for Year and Quarter
      D. Create calculated fields for each date part and display them side by side

      Solution

      1. Step 1: Identify best practice for drill-down in Tableau

        Using a date hierarchy with levels Year > Quarter > Month > Day allows smooth drill-down in one view.

      2. Step 2: Compare other options

        Separate sheets or manual filters are more complex and less user-friendly; calculated fields side by side don't enable drill-down.

      3. Final Answer:

        Create a date hierarchy with Year > Quarter > Month > Day and use it in the view with drill-down enabled -> Option A

      4. Quick Check:

        Date hierarchy enables smooth drill-down [OK]
      Hint: Use one hierarchy for drill-down, not separate sheets [OK]
      Common Mistakes:
      • Creating multiple sheets instead of one hierarchy
      • Using only one date part without hierarchy
      • Relying on calculated fields instead of hierarchy