EDUCBA Logo

EDUCBA

MENUMENU
  • Explore
    • EDUCBA Pro
    • PRO Bundles
    • Featured Skills
    • New & Trending
    • Fresh Entries
    • Finance
    • Data Science
    • Programming and Dev
    • Excel
    • Marketing
    • HR
    • PDP
    • VFX and Design
    • Project Management
    • Exam Prep
    • All Courses
  • Blog
  • Enterprise
  • Free Courses
  • Log in
  • Sign Up
Home Data Science Data Science Tutorials Tableau Tutorial Tableau Drill Down
 

Tableau Drill Down

Priya Pedamkar
Article byPriya Pedamkar

Updated March 21, 2023

Tableau Drill Down

 

 

Introduction to Tableau Drill Down

Tableau Drill Down is the feature to represent the hierarchical data view of the visualization. It helps in-depth analysis of a particular dimension and its dimensions with the details of measures. The drill-down reports are context-specific and are created for specific business requirements. Some of the examples of drill-down reports in Tableau is representing sales data for a country, region, state and city levels. Similarly, representing the year, month, the date representation is a common use case for drill-down reports. Tableau provision to view the drill-down feature on the dashboard. Drill down is an important feature in Tableau that adds value to business intelligence(BI).

Watch our Demo Courses and Videos

Valuation, Hadoop, Excel, Mobile Apps, Web Development & many more.

How to use Tableau?

  • We will start with the data source.
  • Connect your dataset to the tableau.
  • Open Tableau Desktop or Public->Click on File->Open (a file which you want to work with, it could be either xlx, pdf, txt, etc.).
  • We have opened the Sample-Superstore database, out of which the orders table has been dragged.

tableua-1

  • Go to the worksheet, where you will see data divided into dimensions and measures. Name a worksheet as you want (we have named it as Drill-Down).

worksheet

  • Drag dimension and measure to rows and columns.
  • Drag the Category and sub-category dimension into rows.
  • Drag Sales into columns.
  • We will get sales as per category and sub-category.
  • For formatting, drag the category into the Color Marks card.
  • Look at the Category section given on the right side of the sheet.

dimensions

We will look into how each region performed.

  • Drag Region dimension into Filters and columns.
  • We can select either all-region or one or two.
  • We have selected all the regions.

standards

We will look more for formatting the worksheet.

  • Drag sub-category into category new window will popup name hierarchy. Give it a name you want. We have given the name Drill Down.
  • Drag region dimension into rows and select 1 or 2 regions only.
  • The Category dimension will get a drill down with a sub-category.
  • Look at the + sign on the category icon.

data

  • If we want data with a sub-category, click on + sign on category dimension. + sign has changed to –

drill down

  • Drag City dimension into Filters (Marks card).
  • Select the city you want.
  • Drag Category into Filters (Marks card) Select the category you want.
  • We can change the color of any filters.

analytics

  • Drag Order Date dimension into columns.

order

  • Order Date dimension has a + sign; click on the drop-down menu we can select the year, day, quarter and month.

date dimension

  • If we select Month, the result will be changed.

result

  • If we drag the Order Date dimension into rows.

order date

  • We can swap the values between columns and rows. A Swap icon is given.

drag sum

  • Drag Sum (Sales) into Color (Marks), a new window will get generated on the right side of the worksheet.
  • Click on Sum(sales) -> select drop down -> click on Edit Colors, select the color you want.

tableau-13

  • We can change the color of sales with more advanced color formation features. Open edit color windows. Click on Stepped Color, we can change a number of steps, and the color palette will show a range of color as per the steps we have chosen.

color

  • We can change SUM(Sales) to average, median, count, minimum, maximum, etc. measure.
  • Click on the drop-down button of SUM(Sales)->select Measure (SUM)->select measure you want.

SUM

  • We have dragged category and sub-category dimension into columns. We have opted for the Furniture category and selected all the sub-categories.

CATEGORY

  • Select dimension->click on drop-down arrow->select show filter->new window will open on the right side of the worksheet.
  • We can select any data created on the right side and display the result we want.

down arrow

  • Drag State dimension into Label; it will display data state wise.
  • We have selected the year date – 2015 and 2017; data will be shown for these two years only.

tableua-18

  • We have seen some of the sales for each region, category, state.

state

Create Map View

  • As a first step, create a hierarchy with Postal code, state, and country dimension.
  • Go to Country->click on drop-down bar->select Hierarchy->Create hierarchy->give a name to hierarchy (we have given name as the map).

go to country

  • Double click on state dimension or drag state dimension to label, Map will get created.

double click

  • Tableau automatically created a map because tableau knows the state is geographic data.
  • The County dimension is added by default because, in a sample database, the country is part of the hierarchy.
  • Each level of the hierarchy is added to the details.
  • Each location is needed for a map view that the reason longitude and latitude are added.
  • Drag Profit measure to color, we can see some of the profit for each state.

automatically

  • Color is automatically added for each state based on profit. View automatically updated filled map.

tableau-23

  • We will drag the region dimension into filters. We can see a profit by region wise.

edit color

  • We can change the color of profit; we can see what profit each state is getting.
  • Go to Color->Edit color->Select stepped color->select color (from color palatte).

tableau-25

  • Drag Sales measure and region dimension to Label; we will get to see a sale for each state and region.

drag sales

  • We can see in the below image sales a profit for the state with region and country.

tableau-27

Drill Down with Map

  • We will see the profit for each region with a drill-down approach.
  • Copy map view worksheet. Click on worksheet->click on a duplicate.
  • Duplicate sheets will be created.
  • Go to show Me -> select bar graph.

map

profit

  • Select the profit area and mark keep only.

tableau-30

tableau-31

  • When we select keep Only, the below image will appear.

tableau-32

tableau-33

  • When we click on state measure, the country will come under state because we have made a hierarchy of it. – sign with the state is given. When we click on – sign country will disappear will rows.
  • When – sign with the state.

tableau-34

  • When + sign with the state.

tableau-35

  • If we click on + sign on the state, a date will be shown country wise.

tableau-36

Conclusion- Tableau Drill Down

Drill Down is one of the most useful features tableaus has offered. Visualization makes it easy to view with it. When there is a large data source, we can view each data by using the drill down. Tableau is easy to use tool, easy to understand each feature it provides.

Recommended Articles

This is a guide to the Tableau Drill Down. Here we have discussed the Introduction along with Create Map View and Drill Down the Map. You can also go through our other suggested articles to learn more–

  1. Tableau Competitors
  2. What is Tableau?
  3. Line Chart in Tableau
  4. What is the Tableau Server?

Primary Sidebar

Footer

Follow us!
  • EDUCBA FacebookEDUCBA TwitterEDUCBA LinkedINEDUCBA Instagram
  • EDUCBA YoutubeEDUCBA CourseraEDUCBA Udemy
APPS
EDUCBA Android AppEDUCBA iOS App
Blog
  • Blog
  • Free Tutorials
  • About us
  • Contact us
  • Log in
Courses
  • Enterprise Solutions
  • Free Courses
  • Explore Programs
  • All Courses
  • All in One Bundles
  • Sign up
Email
  • [email protected]

ISO 10004:2018 & ISO 9001:2015 Certified

© 2025 - EDUCBA. ALL RIGHTS RESERVED. THE CERTIFICATION NAMES ARE THE TRADEMARKS OF THEIR RESPECTIVE OWNERS.

EDUCBA

*Please provide your correct email id. Login details for this Free course will be emailed to you
EDUCBA

*Please provide your correct email id. Login details for this Free course will be emailed to you

EDUCBA
Free Data Science Course

Hadoop, Data Science, Statistics & others

By continuing above step, you agree to our Terms of Use and Privacy Policy.
*Please provide your correct email id. Login details for this Free course will be emailed to you
EDUCBA

*Please provide your correct email id. Login details for this Free course will be emailed to you
EDUCBA Login

Forgot Password?

Loading . . .
Quiz
Question:

Answer:

Quiz Result
Total QuestionsCorrect AnswersWrong AnswersPercentage

Explore 1000+ varieties of Mock tests View more

🚀 Limited Time Offer! - ENROLL NOW