Tableau - Waterfall Charts


Advertisements

Waterfall charts effectively display the cumulative effect of sequential positive and negative values. It shows where a value starts, ends and how it gets there incrementally. So, we are able to see both the size of changes and difference in values between consecutive data points.

Tableau needs one Dimension and one Measure to create a Waterfall chart.

Creating a Waterfall Chart

Using the Sample-superstore, plan to find the variation of Sales for each Sub-Category of Products. To achieve this objective, following are the steps.

Step 1 − Drag the Dimension Sub-Category to the Columns shelf and the Measure Sales to the Rows shelf. Sort the data in an ascending order of sales value. For this, use the sort option appearing in the middle of the vertical axis when you hover the mouse over it. The following chart appears on completing this step.

water fall 1

Step 2 − Next, right-click on the SUM (Sales) value and select the running total from the table calculation option. Change the chart type to Gantt Bar. The following chart appears.

water fall 2

Step 3 − Create a calculated field named -sales and mention the following formula for its value.

water fall 3

Step 4 − Drag the newly created calculated field (-sales) to the size shelf under Marks Card. The chart above now changes to produce the following chart which is a Waterfall chart.

water fall 4

Waterfall Chart with Color

Next, give different color shades to the bars in the chart by dragging the Sales measure to the Color shelf under the Marks Card. You get the following waterfall chart with color.

water fall final

Useful Video Courses


Video

Tableau Online Training

Best Seller

88 Lectures 10 hours

Pavan Lalwani

Video

49 Charts in Tableau - (Latest Version)

64 Lectures 4 hours

Pavan Lalwani

Video

Visualising Data using Tableau

18 Lectures 1 hours

PARTHA MAJUMDAR

Video

Tableau Hands-on: Learn Data Visualization with Tableau

45 Lectures 5.5 hours

TELCOMA Global

Video

Master Data Visualization with Tableau

14 Lectures 53 mins

Harshit Srivastava

Video

Learn data visualization by tableau

40 Lectures 3.5 hours

Sanjeev

Advertisements