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

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.

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.

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.

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.

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.

Which level is NOT part of a standard date hierarchy in Tableau?

A Quarter

B Year

C Weekday

D Month

Weekday is not a standard level in the typical date hierarchy of Year, Quarter, Month, and Day.

How do you add a date hierarchy in Tableau?

A Right-click date field → Create → Hierarchy

B Double-click the date field

C Use the Data Source tab to merge dates

D Drag and drop date fields into a new folder

You create a date hierarchy by right-clicking a date field, then choosing Create → Hierarchy.

What is the main benefit of using a date hierarchy?

A It automatically formats dates as text

B It removes duplicate dates

C It creates calculated fields

D It allows easy drill-down from year to day

Date hierarchies let you drill down smoothly from broad to detailed time levels.

When you expand a date hierarchy in Tableau, what happens?

A The data is filtered by the selected date

B The view shows more detailed time levels like months or days

C The date field is removed

D The data source refreshes

Expanding a date hierarchy reveals more detailed levels such as months and days.

Which of these is the correct order of levels in a date hierarchy?

A Year → Quarter → Month → Day

B Month → Quarter → Year → Day

C Day → Month → Quarter → Year

D Quarter → Year → Day → Month

The standard order is Year, then Quarter, then Month, then Day.

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.

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.