Two Ways to Build Funnel Charts in Tableau

Data

Two Ways to Build Funnel Charts in Tableau

Often in my training classes, I find students who are building dashboards to monitor a linear workflow such as an HR recruiting pipeline or order fulfillment. Tableau is an excellent BI tool to monitor these workflows, and a funnel chart is a powerful, easy-to-build visual that can provide valuable insight into your data.

Funnel charts are a great way to track progress through a workflow with multiple steps. They can highlight how well a process is being followed and easily identify any bottlenecks. You can even use table calculations to look at different ways to measure progress to each step (percent of total, percent change, etc.).

There are two easy to build funnel charts in Tableau: a Stepped Funnel Chart and a Smooth Funnel Chart.

Stepped Funnel Chart

Step 1: Set the default sort order for the stages of your data (Tableau will default to alphabetical).

Tableau Funnel Charts: Set Default Order

Step 2: Drag your record Count field on to the Rows shelf. This may be the Number of Records field provided by Tableau or an ID dimension field. Ensure the Count or Count Distinct aggregate function is selected.

Tableau Funnel Charts: Count to Rows

Step 3: Drag the Dimension pill, which includes your stages, onto Color.

Tableau Funnel Charts: Drag Dimension to Color

Step 4: Make a copy of your Count field and drag it from the Rows shelf onto the Size tile in the Marks card.

Tableau Funnel Charts: Copy Count to Marks

Step 5: Change the view fit from Standard to Entire View.

Tableau Funnel Charts: Change View

Step 6: Add labels and format the chart to your liking.

Tableau Funnel Charts: Label and Format

Smooth Funnel Chart

Step 1: Set the default sort order for the stages of your data (Tableau will default to alphabetical).

Tableau Set Default Order

Step 2: Drag the Dimension pill, which includes your stages, onto the Rows shelf.

Tableau Funnel Charts: Drag Dimension to Rows

Step 3: Drag your Count field on to the Columns shelf and change the mark to Area Line.

Tableau Funnel Charts: Drag Fields to Columns, Change to Area Line

Step 4: Change the view fit from Standard to Entire View.

Tableau Funnel Charts: Change View

Step 5: Create a calculated field for the inverse value of your Count field and drag it onto the Columns shelf to the left of your original Count field.

Tableau Funnel Charts: Create Calculated Field

Step 6: Add labels and format the chart to your liking.

Tableau Funnel Charts: Add Labels and Format

More About the Author

Dave Sirey

Analytics Consultant
Synchronize Axes Across Multiple Sheets in Five Simple Steps I often find myself building dashboards with a parameter to compare baseline data to different scenarios. Because these scenarios are ...
Two Ways to Build Funnel Charts in Tableau Often in my training classes, I find students who are building dashboards to monitor a linear workflow such as an HR recruiting ...

See more from this author →

Subscribe to our newsletter

  • I understand that InterWorks will use the data provided for the purpose of communication and the administration my request. InterWorks will never disclose or sell any personal data except where required to do so by law. Finally, I understand that future communications related topics and events may be sent from InterWorks, but I can opt-out at any time.
  • This field is for validation purposes and should be left unchanged.

InterWorks uses cookies to allow us to better understand how the site is used. By continuing to use this site, you consent to this policy. Review Policy OK

×

Interworks GmbH
Ratinger Straße 9
40213 Düsseldorf
Germany
Geschäftsführer: Mel Stephenson

Kontaktaufnahme: markus@interworks.eu
Telefon: +49 (0)211 5408 5301

Amtsgericht Düsseldorf HRB 79752
UstldNr: DE 313 353 072