Organizing Data Using Folders and Hierarchies in Tableau

Course: Tableau Data Visualization and Business Intelligence

Topic: Organizing Data Using Folders and Hierarchies

Course Link: JustAcademy Tableau Training

Demo Link: Register for a Tableau Course Demo

1. Introduction

Tableau provides several features to help users organize fields and analyze data efficiently. When a dataset contains many columns, finding the right field in the Data pane can become difficult. Folders and hierarchies help solve this problem by organizing related fields and arranging them into meaningful levels.

Folders group related fields together to make the Data pane easier to navigate. Hierarchies arrange related fields into levels so that users can explore data from a broader view to a more detailed view.

For example, a sales dataset might contain Customer Name, Customer ID, Region, State, City, Category, Sub-Category, Sales, Profit, and Order Date. You can organize these fields into folders such as Customer Information, Geography, Product Details, and Financial Metrics. You can also create hierarchies such as Country → State → City or Category → Sub-Category → Product Name.

Official references: Organize and Customize Fields in the Data Pane and Create Hierarchies.

2. Learning Objectives

After studying this topic, you will be able to:

• Understand how Tableau organizes fields in the Data pane.
• Explain the difference between folders and hierarchies.
• Create folders for related dimensions, measures, and other supported items.
• Add fields to folders and reorganize the Data pane.
• Create custom hierarchies using related fields.
• Arrange hierarchy levels in the correct order.
• Drill down and drill up in a visualization.
• Use folders and hierarchies in practical dashboard development.
• Identify common mistakes and apply data organization best practices.

3. Understanding the Data Pane in Tableau

The Data pane appears on the left side of a Tableau worksheet. It contains the fields available from the selected data source. These fields are used to build charts, tables, maps, filters, and dashboards.

3.1 Common Field Types

Dimensions and measures are displayed in separate sections of the Data pane. The exact arrangement can depend on the selected grouping option and the connected data source.

3.2 Why Organize Fields?

• Large datasets may contain dozens or hundreds of fields.
• Similar field names can make navigation confusing.
• Business users need clear and understandable field groupings.
• Related fields are easier to locate when grouped logically.
• Hierarchies make it easier to explore information at different levels of detail.
• Well-organized data sources are easier to maintain and share with a team.

4. What Are Folders in Tableau?

Folders are organizational containers in the Data pane that allow you to group related fields and supported items together. They improve the structure of the field list but do not automatically create a parent-child relationship between the fields.

For example, a sales dataset might contain Sales, Profit, Discount, and Quantity. You can create a folder named Financial Metrics and place these fields inside it.

4.1 Example of Folder Organization

Before organizing the fields, the Data pane might contain:

• Customer Name
• Customer ID
• Region
• State
• City
• Category
• Sub-Category
• Product Name
• Sales
• Profit
• Discount
• Quantity

After organizing them into folders, the structure could look like this:

Data Pane
├── Customer Information
│   ├── Customer Name
│   └── Customer ID
├── Geography
│   ├── Region
│   ├── State
│   └── City
├── Product Details
│   ├── Category
│   ├── Sub-Category
│   └── Product Name
└── Financial Metrics
    ├── Sales
    ├── Profit
    ├── Discount
    └── Quantity

This structure makes fields easier to locate. The folder names are organizational labels; they do not change the underlying data or define drill-down relationships.

5. How to Create Folders in Tableau

Step 1: Connect to a Data Source

Open Tableau Desktop and connect to a dataset such as Sample - Superstore. Open a worksheet to view the fields in the Data pane.

Step 2: Change the Grouping Option

Open the Data pane menu and select Group by Folder. Depending on the current configuration, you may also right-click a field and choose Group by → Folder.

Tableau can organize fields by folder or by the data source table. Grouping by folder is useful when you want to design your own field organization.

Step 3: Select Fields

Select the fields you want to organize together. For example, select Sales, Profit, Discount, and Quantity to prepare a folder for financial and performance metrics.

Step 4: Create the Folder

1. Right-click the selected fields or an appropriate blank area of the Data pane.
2. Choose Folders → Create Folder.
3. Enter a meaningful folder name, such as Financial Metrics.
4. Confirm the folder creation.

Step 5: Add Fields to the Folder

You can add fields by dragging a field onto the folder name or by right-clicking a field and choosing Folder → Add to Folder, then selecting the desired folder.

Step 6: Review the Organization

Expand and collapse the folders to check that the fields are grouped logically. Rename folders if necessary to make their purpose clear.

Important: A field can belong to only one folder at a time. If you need the same field available in more than one folder, you can duplicate the field and organize the duplicate separately.

6. Adding, Removing, and Managing Folders

6.1 Adding a Field to an Existing Folder

1. Locate the field in the Data pane.
2. Right-click the field.
3. Choose Folder → Add to Folder.
4. Select the destination folder.
5. Verify that the field appears in the intended location.

6.2 Moving a Field Between Folders

Move the field to the required folder by dragging it onto the folder or using the folder context menu. Since fields can belong to only one folder, reorganizing a field changes its folder membership.

6.3 Renaming a Folder

Use the folder's context menu to access the available rename option, if provided in your Tableau version. Choose a clear name that describes the fields contained in the folder.

6.4 Removing a Folder

Use the folder's context menu to remove the folder when it is no longer useful. Review the available options carefully: removing an organizational folder is different from deleting the underlying data field.

6.5 Grouping by Table or Folder

Tableau preserves folder information when you switch between folder and table grouping. The available grouping features depend on the type of data source; group and sort options described in Tableau Desktop documentation are intended for relational data sources rather than cube data sources.

7. Best Practices for Creating Folders

• Use names that clearly describe the fields inside each folder.
• Group fields according to business function, such as Customer, Product, Geography, or Finance.
• Avoid creating too many small folders that make navigation more complicated.
• Keep related fields together where possible.
• Use consistent naming conventions across workbooks and data sources.
• Do not assume folders create relationships or calculations between fields.
• Consider grouping by table when users need to understand the source of fields.
• Use Tableau's Data pane search to find fields in large datasets.

8. What Are Hierarchies in Tableau?

A hierarchy is an ordered collection of related fields that represents different levels of detail. Hierarchies allow users to drill down from a high-level summary to more detailed information within a visualization.

For example, a geographical hierarchy can contain Country, State, City, and Postal Code. A user can begin with country-level sales, expand a country to see its states, and then expand a state to examine its cities.

8.1 Example of a Geography Hierarchy

Geography Hierarchy
└── Country
    └── State
        └── City
            └── Postal Code

When you use the hierarchy in a visualization, Tableau can provide expand and collapse controls that let you move between the levels of detail.

8.2 Common Types of Hierarchies

These examples represent common analytical structures. You should only combine fields into a hierarchy when the sequence makes sense for your dataset and analysis.

9. How to Create a Hierarchy in Tableau

Step 1: Identify Related Fields

Choose fields that represent different levels of detail. For example, select Category, Sub-Category, and Product Name from Sample - Superstore.

Step 2: Drag One Field onto Another

In the Data pane, drag the field that should become a lower level of detail directly onto the field that should appear at the top level.

For example, drag Sub-Category onto Category. When Tableau prompts you, provide a name for the hierarchy, such as Product Hierarchy.

Step 3: Name the Hierarchy

Enter a descriptive name, such as Product Hierarchy, Geography Hierarchy, or Customer Hierarchy, and confirm.

Step 4: Add More Fields

Drag additional related fields into the hierarchy. For the product example, add Product Name beneath Sub-Category.

Step 5: Arrange the Levels

Review the order of the fields and drag them into the intended sequence if necessary.

Step 6: Test the Hierarchy

1. Drag the top-level field from the hierarchy into Rows or Columns.
2. Add a measure such as Sales to the view.
3. Look for the expand or plus control associated with the hierarchy level.
4. Click the control to reveal the next level of detail.
5. Continue drilling down until you reach the desired level.

Alternative method: When creating a hierarchy from a field inside a folder, right-click the field and select Create Hierarchy, if available in your Tableau interface.

Official reference: Create Hierarchies in Tableau.

10. Understanding Drill Down and Drill Up

Drill down means moving from a broader level to a more detailed level. Drill up means returning to a higher-level summary.

Example: Sales by Geography

Imagine that a company wants to analyze sales across countries, states, and cities.

1. Country level: View total sales for each country.
2. State level: Expand a country to see sales for its states.
3. City level: Expand a state to see sales for its cities.
4. Postal Code level: Continue to a more detailed geographical level, if included.

The hierarchy lets the user explore detailed information without manually rebuilding the view from scratch for every level.

Example Hierarchy

Country
  ↓ Drill Down
State
  ↓ Drill Down
City
  ↓ Drill Down
Postal Code
  ↑ Drill Up to return to a broader level

Note: A hierarchy organizes fields for interactive exploration; it does not automatically filter or remove underlying records. The level of detail displayed changes as the hierarchy is expanded or collapsed.

11. Folders vs. Hierarchies

Key point: Folders help organize the field list; hierarchies help organize analytical levels. They serve different purposes and can be used together.

12. Practical Project: Organize a Sales Dataset

Project Objective: Organize a retail sales dataset using folders and hierarchies, then create a view that allows users to explore sales at different levels of detail.

Sample Fields

Project Steps

1. Connect to Sample - Superstore or a similar retail dataset.
2. Change the Data pane grouping to Group by Folder.
3. Create a Customer Information folder.
4. Create a Financial Metrics folder.
5. Add relevant fields to their folders.
6. Create a Geography hierarchy using Country, State, and City.
7. Create a Product hierarchy using Category, Sub-Category, and Product Name.
8. Drag Sales to the view and add the Geography hierarchy.
9. Expand the hierarchy to compare sales across different locations.
10. Create another worksheet using the Product hierarchy and Sales.
11. Compare category-level results with product-level results.
12. Save the workbook and verify that the Data pane remains easy to navigate.

Expected Outcome

• Fields are grouped into logical folders.
• Users can find important measures and dimensions quickly.
• Geographical analysis supports drill-down from country to city.
• Product analysis supports drill-down from category to product.
• The workbook is easier to maintain and use collaboratively.

13. Common Mistakes and Solutions

14. Best Practices for Folders and Hierarchies

Folder Best Practices

• Organize fields by business purpose or functional area.
• Keep folder names short, clear, and consistent.
• Group commonly used fields together.
• Use table grouping when tracing fields back to source tables is more useful.
• Use search in the Data pane when a dataset contains many fields.

Hierarchy Best Practices

• Build hierarchies from broad levels to detailed levels.
• Use a logical order that reflects the data's meaning.
• Test each level before using the hierarchy in a dashboard.
• Use descriptive names for hierarchies.
• Avoid adding fields merely because they are related to the same business topic; they should form a meaningful sequence.
• Make sure the data supports the intended drill-down path.

15. Interview Questions and Answers

Q1. What are folders in Tableau?

Answer: Folders are organizational containers in the Data pane that group related fields and supported items, making large datasets easier to navigate.

Q2. What is a hierarchy in Tableau?

Answer: A hierarchy is an ordered collection of related fields that allows users to move between different levels of detail in a visualization.

Q3. What is the main difference between folders and hierarchies?

Answer: Folders group fields for organization, while hierarchies arrange related fields into levels that support drill-down and drill-up analysis.

Q4. How do you create a folder in Tableau?

Answer: Set the Data pane to Group by Folder, select the relevant fields or an appropriate blank area, right-click, select Folders → Create Folder, and provide a name.

Q5. How do you create a hierarchy?

Answer: Drag one field onto another in the Data pane, provide a name when prompted, and add or reorder fields to establish the hierarchy levels.

Q6. What is drill-down analysis?

Answer: Drill-down analysis moves from summarized information to more detailed information, such as Country → State → City.

Q7. What is drill-up analysis?

Answer: Drill-up analysis returns from a detailed level to a broader summary level in a hierarchy.

Q8. Can a field belong to more than one folder?

Answer: A field can appear in only one folder at a time. If the same field is needed in multiple folders, you can duplicate it and organize the duplicate separately.

Q9. Can folders create relationships between tables?

Answer: No. Folders organize fields in the Data pane. Relationships between tables are configured separately in Tableau's data model.

Q10. Give an example of a product hierarchy.

Answer: Category → Sub-Category → Product Name is a common product hierarchy that allows users to explore sales from broad categories to individual products.

Q11. Why are hierarchies useful in dashboards?

Answer: They allow users to explore detailed information interactively without having to create a separate visualization for every level of detail.

Q12. What should you consider when designing a hierarchy?

Answer: The fields should have a logical relationship, the level order should make sense, and the hierarchy should support the analytical questions users need to answer.

16. Practical Exercises

Exercise 1: Create Folders

Using Sample - Superstore, create Customer Information, Product Details, Geography, and Financial Metrics folders. Add the appropriate fields to each folder.

Exercise 2: Create a Geography Hierarchy

Create a hierarchy using Country, State, and City. Build a view that displays Sales and test the drill-down behaviour.

Exercise 3: Create a Product Hierarchy

Create a hierarchy using Category, Sub-Category, and Product Name. Explore how the view changes as you move to more detailed levels.

Exercise 4: Compare Folder and Hierarchy Usage

Explain why placing Country, State, and City in a folder does not provide the same drill-down behaviour as creating a hierarchy.

Exercise 5: Improve a Messy Data Pane

Connect to a dataset with many fields. Organize its fields into meaningful folders, rename unclear fields where appropriate, and create at least one hierarchy that supports a useful analysis.

17. Quick Revision Notes

• Folders group related fields in the Data pane.
• Hierarchies organize related fields into ordered levels.
• Group by Folder enables manual field organization.
• Fields can be added to folders using drag-and-drop or the field context menu.
• A field can belong to only one folder at a time.
• Hierarchies can be created by dragging one field onto another.
• Hierarchy levels can be reordered.
• Drill down moves toward greater detail.
• Drill up returns to a broader summary.
• Country → State → City is a common geography hierarchy.
• Category → Sub-Category → Product Name is a common product hierarchy.
• Folders do not create table relationships or hierarchy drill-down behaviour by themselves.

18. Final Checklist

• Understand the purpose of the Data pane.
• Identify dimensions, measures, dates, and calculated fields.
• Set the grouping option to Folder when custom organization is required.
• Create folders with clear names.
• Move related fields into the appropriate folders.
• Create hierarchies from related fields.
• Arrange levels from broad to detailed.
• Test drill-down and drill-up behaviour in a worksheet.
• Confirm that folders and hierarchies improve usability.
• Save the workbook and check that other users can understand the field organization.

19. Conclusion

Organizing data using folders and hierarchies is an important Tableau skill. Folders make the Data pane cleaner and easier to navigate, while hierarchies provide a structured way to explore data at different levels of detail. Together, they help analysts create more usable workbooks, simplify data exploration, and improve dashboard usability.

For best results, use folders to group fields by purpose and hierarchies to define meaningful drill-down paths. Always test your organization in a worksheet to ensure it supports the needs of the intended users.

Explore the course: JustAcademy Tableau Training

Book a course demo: Register for a Tableau Course Demo