EDUCBA

EDUCBA

MENUMENU
  • Free Tutorials
  • Free Courses
  • Certification Courses
  • 360+ Courses All in One Bundle
  • Login

Tableau Drill Down

By Priya PedamkarPriya Pedamkar

Home » Data Science » Data Science Tutorials » Tableau Tutorial » Tableau Drill Down

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).

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 orders table has been dragged.

tableua-1

Start Your Free Data Science Course

Hadoop, Data Science, Statistics & others

  • 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 category into 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 advance 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 country is the 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 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 feature tableaus has offered. Visualization makes 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 a 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?

Tableau Training (4 Courses, 6+ Projects)

4 Online Courses

6 Hands-on Projects

39+ Hours

Verifiable Certificate of Completion

Lifetime Access

Learn More

0 Shares
Share
Tweet
Share
Primary Sidebar
Tableau Tutorial
  • Advanced
    • Tableau Reporting
    • Tableau Reporting Tool
    • Conditional Formatting in Tableau
    • Data Blending in Tableau
    • Parameters in Tableau
    • Tableau Data Sets
    • Tableau Drill Down
    • Tableau Dynamic Parameters
    • Tableau Table Calculation
    • Tableau Visualization
    • Tableau Joins
    • Pivot in Tableau
    • Data Visualization With Tableau
    • Forecast in Tableau
    • Map Layers in Tableau
    • Group in Tableau
    • Tableau Group by
    • Hierarchy in Tableau
    • Sets in Tableau
    • How to create a Set in Tableau
    • Tableau Order of Operations
    • Tableau User Group
    • Tableau Calculated Field
    • Custom SQL in Tableau
  • Basic
    • What is Tableau
    • What is Tableau Dashboard
    • What is Tableau Server
    • Uses of Tableau
    • Tableau Versions
    • Tableau Architecture
    • Is Tableau Free
    • Tableau New Features
    • How To Install Tableau
    • How to Use Tableau?
    • Install Tableau Server
    • Tableau Commands
  • Charts
    • Tableau Charts
    • Tableau Chart Types
    • Donut Chart in Tableau
    • Funnel Chart in Tableau
    • Gantt Chart in Tableau
    • Bubble Chart in Tableau
    • Pareto Chart in Tableau
    • Sankey Chart In Tableau
    • Stacked Bar Chart in Tableau
    • Tableau Bullet Chart
    • Waterfall Chart in Tableau
    • Line Chart in Tableau
    • Heat Map in Tableau
    • Histogram in Tableau
    • CrossTab in Tableau
    • Treemap in Tableau
    • Trend Lines in Tableau
    • Tableau Reference Lines
    • Tableau Dual Axis
    • Legend in Tableau
    • Pie Chart in Tableau
    • Tableau Storyline
  • Statement
    • Tableau IF Statement
    • Case Statement in Tableau
  • Functions
    • Tableau Functions
    • Tableau String Functions
    • Concatenate in Tableau
    • Rank Function in Tableau
    • Tableau Aggregate Functions
    • Tableau Date Functions
    • Window Sum Tableau
    • LOD Expressions in Tableau
    • LOOKUP Function in Tableau
    • Tableau Fixed Function
    • Tableau Count Distinct
    • Tableau Window Functions
  • Sort/Filters
    • Sorting in Tableau
    • Filters in Tableau
    • Types of Filters in Tableau
    • Tableau Action Filter
    • Context Filter in Tableau
    • Tableau Parameter Filter
    • Adding Filters in Tableau Dashboard
    • Tableau Context Filter
  • Tableau Dashboard
    • Dashboard in Tableau
    • Tableau Dashboard Creation
    • Tableau Dashboard Design
    • Tableau Workbook
  • Interview Questions
    • Tableau Interview Questions

Related Courses

Tableau Certification Course

Business Intelligence Courses

Data Visualization Courses

Footer
About Us
  • Blog
  • Who is EDUCBA?
  • Sign Up
  • Corporate Training
  • Certificate from Top Institutions
  • Contact Us
  • Verifiable Certificate
  • Reviews
  • Terms and Conditions
  • Privacy Policy
  •  
Apps
  • iPhone & iPad
  • Android
Resources
  • Free Courses
  • Database Management
  • Machine Learning
  • All Tutorials
Certification Courses
  • All Courses
  • Data Science Course - All in One Bundle
  • Machine Learning Course
  • Hadoop Certification Training
  • Cloud Computing Training Course
  • R Programming Course
  • AWS Training Course
  • SAS Training Course

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

EDUCBA Login

Forgot Password?

EDUCBA
Free Data Science Course

Hadoop, Data Science, Statistics & others

*Please provide your correct email id. Login details for this Free course will be emailed to you
Book Your One Instructor : One Learner Free Class

Let’s Get Started

This website or its third-party tools use cookies, which are necessary to its functioning and required to achieve the purposes illustrated in the cookie policy. By closing this banner, scrolling this page, clicking a link or continuing to browse otherwise, you agree to our Privacy Policy

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

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

Special Offer - Tableau Training (4 Courses, 6+ Projects) Learn More