Date hierarchy (year, quarter, month, day) in Tableau - Step-by-Step Guide

Introduction

Date hierarchy lets you explore your data by different time levels like year, quarter, month, and day. It helps you see trends over time easily without creating separate fields for each date part.

When you want to analyze sales trends by year, then drill down to quarters, months, and days.

When your dashboard needs to show time-based data with easy zoom-in and zoom-out options.

When you want to compare performance across different time periods quickly.

When you want to create a timeline view that users can explore interactively.

When you need to filter or group data by different date parts without extra calculations.

Steps

Step 1: Open your Tableau workbook and go to the worksheet with your date field

- Data pane

You see your date field listed, usually with a calendar icon

Step 2: Click the plus (+) sign next to your date field

- Data pane next to the date field

Tableau expands the date field into a hierarchy showing Year, Quarter, Month, and Day

Step 3: Drag the date hierarchy to Rows or Columns shelf

- Rows or Columns shelf

The view shows data aggregated by the highest level, usually Year

Step 4: Click the plus (+) icon next to a year in the view

- View area on the Year header

The view drills down to show Quarters within that year

Step 5: Click the plus (+) icon next to a quarter

- View area on the Quarter header

The view drills down to show Months within that quarter

Step 6: Click the plus (+) icon next to a month

- View area on the Month header

The view drills down to show Days within that month

Before vs After

Before

The view shows total sales by year only, with no option to see quarters or months

After

The view allows clicking plus (+) icons to drill down from year to quarter, month, and day, showing detailed sales data at each level

Settings Reference

Date field type

📍 Data pane next to the date field

Ensures Tableau recognizes the field as a date to create hierarchy

Default: Date

Show/Hide Hierarchy Levels

📍 View area, plus (+) or minus (-) icons next to date parts

Controls how much detail is shown in the date hierarchy

Default: Collapsed at Year level

Common Mistakes

Trying to create a date hierarchy manually by splitting date fields

Tableau already provides automatic date hierarchies for date fields, so manual splitting is unnecessary and error-prone

Use the built-in date hierarchy by clicking the plus (+) sign next to the date field

Dragging the date field without expanding the hierarchy

This shows only one level (usually year) and limits drill-down options

Expand the hierarchy first by clicking the plus (+) sign, then drag the full hierarchy to the view

Summary

Date hierarchy lets you explore data by year, quarter, month, and day easily.

Use the plus (+) icons to drill down or collapse levels in your view.

Always use Tableau's built-in date hierarchy for accurate and simple time analysis.