Tableau will automatically create a hierarchy for which two kinds of data? (Choose two.)

Question

Options

• ADate & Time
• BDate
• CString
• DGeographic

• A
  93% (55)
• C
  5% (3)
• D
  2% (1)

Explanation

Tableau automatically creates drill-down hierarchies for Date & Time (A) and Date (B) fields because time-based data has a natural, universally recognized structure - Year → Quarter → Month → Week → Day (and for Date & Time, further down to Hour → Minute → Second). Tableau builds these hierarchies the moment it detects those data types in your source, requiring no manual setup.

Why C is wrong: String fields have no inherent order or structure Tableau can infer - they're just text. You'd need to manually create a hierarchy (e.g., Region → State → City) from string columns yourself.

Why D is wrong: Geographic fields get geographic roles assigned automatically (e.g., State, Country), but they do not get a pre-built hierarchy automatically - you still have to drag fields together to create one.

Memory tip: Think "clocks and calendars" - Tableau only auto-builds hierarchies for fields that follow a built-in time structure. If the data isn't inherently time-based, Tableau won't assume a hierarchy exists.

No community discussion yet for this question.