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 Funnel Chart in Tableau
 

Funnel Chart in Tableau

Priya Pedamkar
Article byPriya Pedamkar

Updated March 20, 2023

funnel chart in tableau

 

 

Introduction to Funnel Chart in Tableau

Before we start going into the details about how funnel chart is plotted in tableau, Let’s first get to know what funnel chart is? So, Funnel chart as the name suggests when plotted represents like a funnel. It shows values that gradually decrease ratios amounting to 100%. The higher part is called the head and the lower part is called a neck. They can be used to show anything that is decreasing in size. We can say funnel chart as some sort of alternative to the pie chart because the total area covered by both is 100 percent and the only difference is that in the funnel chart we have decreasing area size for example:

Watch our Demo Courses and Videos

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

  • One bar with an area of 60 percent
  • The second one with an area of 20 percent
  • Then next one with 15 percent
  • And the last one with an area of 5 percent

So for example, if we have a total of 500 employees in an office of varying skills and we want to plot the number of employees of a particular skill in a decreasing order we can choose the funnel plot. So suppose we have 300 employees with Python, 150 with knowledge of R and 50 with knowledge of SPSS. The head of the funnel chart can be 300 employees with Python and the neck can be 50 with SPSS and the middle layer belongs to 150 with knowledge of R.

So, after the introduction of the funnel chart, we will now shift our attention to Tableau which will be used to visualize the funnel chart.

A tableau is a tool that is used for visualization. It is used for visually analyzing the data. A person can create an interactive sharable dashboard using Tableau and that dashboard can be used to depict trends, variations in data using graphs and charts. It is not open source but a student version is available. The interesting part about it is it allows real-time data analysis. It can be used to connect to files, big data sources. It is used in academics, business, and many government organizations.

Building of Tableau Charts

So, now let’s start building the tableau charts. So, we will have two approaches to build the funnel charts in tableau

Approach 1 – (Stepped Funnel Chart)

1. Open Tableau and you will find the below screen.

2. Connect to a file using a connect option present in a Tableau landing page. In my case, I have an excel file to connect. Select the excel option and browse your file to connectStepped funnel chart

3. I am using office supplies dataset which has six attributes and includes both numeric and categorical values. The below screenshot shows how it looks in tableau once you connect to your sheet. If you look closely there are two attributes (Units and Unit Price) in the measurement region and four (Region, Rep, Item, Date) in the dimension region.

office supplies

4. Click on sheet1 shown with the tooltip ”Go to Worksheet”. This is where you will prepare your visualizations. The below screenshot shows how it looks.Go to Worksheet

5. As we have to now prepare a funnel chart so for that we need to drag and drop any measured value in the rows. Remember one thing that before you do that you should have selected the aggregate function as “Counts” or “Counts (distinct)”. Once you drag and drop in the rows you will see a single bar reflecting the counts as shown in the below screenshot.

funnel chart

6. Now, after that, we can drag the dimensional field into the “color” region in the “marks” card of the tableau worksheet which in this case region as it will allow us the bar to be divided into groups. Here we have three groups in the data source which are east, central and west. The same is shown in the below Screenshot.colour region

7. Now, the next step is to just press ctrl and drag the measured value present in rows to size section in marks card. Remember to press and hold the ctrl while dragging the number of records present in rows section as it will create a new copy of the measured value and will distinguish the sections in the bar as further into size. So, the bar graph has now been further split based on region and size. The below screenshot shows the same.split based

8. Now to convert the above into funnel chart. Just change the view bar present in the toolbar from “standard” to “Entire View” and it will be converted into a funnel chart as shown in the below screenshot.Toolbar view

Approach 2 – (Smooth Funnel Chart)

1. The first four steps will remain the same and from step 5 the approach will change. For this approach we have to first sort the region from the dimension field by right-clicking the region >default properties> sort and then the drag and drop the dimension field region into rows shelf. The below screenshot illustrates the same.dimension change

2. The next step will be to drag and drop the measure field “Number of Records” into the Column shelf. Remember to change the default properties to counts or counts (distinct). Below Screenshot shows the same.Funnel Chart In Tableau - Number of records

3. Once you have done this, now change the Marks shelf to “Area” from “Automatic” using the drop-down present. Below Screenshot shows the same.Funnel Chart In Tableau - Marks shelf

4. The next step is to create a calculated field or inverse of the count field (Number of Records) and drag and drop the calculated field in the column shelf. To create a calculated field: Right-click the field (Number of Records)>create>calculated field. Below screenshots shows the calculated field dialog box.Funnel Chart In Tableau - inverse step

5. The final step is to drag and drop the file in the column shelf. Below screenshot shows the same.Funnel Chart In Tableau - Drag and Drop

Conclusion

Funnel charts are generally used when we show something decreasing in size. Below are some areas where they can be used.

  • To visualize the order fulfillment process.
  • To visualize the sales process from start to finish.
  • To visualize the flow of information based on priority.

Recommended Articles

This has been a guide to Funnel Chart In Tableau. Here we discussed the different approaches to build the funnel charts in tableau. You may also look at the following articles to learn more –

  1. Stacked Bar Chart in Tableau
  2. Line Chart in Tableau
  3. Tableau Architecture
  4. Tableau Count Distinct

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
Loading . . .
Quiz
Question:

Answer:

Quiz Result
Total QuestionsCorrect AnswersWrong AnswersPercentage

Explore 1000+ varieties of Mock tests View more

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?

🚀 Limited Time Offer! - 🎁 ENROLL NOW