Tableau Waterfall Chart is a form of data visualization that helps to visualize the Running sum or total of any measure against the Dimension. The Waterfall Charts is a type of Gantt bar that is very useful for comparing Measures over a time period.
For instance, use this Tableau Waterfall Chart for visualizing the Profits (Positive or Negative) of a Month or year to increase or decrease our Production (Decision Making) shown as stacked bars. The height of each bar corresponds to the total value of that time period (month or year), while the color indicates whether its value is positive or negative.
Create a Tableau Waterfall Charts
To create a Waterfall chart, drag and drop the Product Subcategory Name from Dimension Region to Columns Shelf and Order Quantity from Measures region to Rows Shelf of the new sheet. By default, it generates the Bar chart.
As we all know, the Waterfall chart is the modern name of the Running total graph. So, we have to add the Running total to the above-specified graph. Please click on the Order Quantity from Row Shelf. Next, select the Quick Table Calculation option and choose the Running Total.
Please visit Connecting to Server, Bar Graph, and SQL articles to understand the Tableau configurations, data source, and dimension members.
Once you select the Running Total, the following screenshot will be displayed in ascending order.
Now, Please change the Mark type from Automatic to Gantt Bar to create a Tableau waterfall chart. To do this, Please select the Mark Type option for the Order Quantity and select the Gantt Bar for cumulative effect.
As you see, we are closer to the result. Next, we have to specify the size of each cell in the Gantt bar. So, add one more calculated field. Select the Create Calculated Field option from the Analysis Menu.
Once you select the Create Calculated Field option, a new window will be opened to write or edit table calculations. For the following example, we need negative values of order Quantity. So, write the following expression as the table calculations.
Next, Drag and Drop the newly created calculated field (Negative orders) from the Measures region to the Size field present in the Marks card.
As you see our Tableau Waterfall Chart. Gantt Bar cells are sized by the negative value of order quantity.
Add Colors and Row Grand Totals
Let us add some colors to this. For now, we use the Rank (Calculated Field) we created in the Bump graph article to color this report. Drag the Rank from Measures region to Color Field present in Marks card.
NOTE: You can use Profits Measure or KPI trends and Goals On the color shelf to visualize them in Waterfall Chart.
By Default Rank field will rank using Table Across. So, Please change the quick table calculation from Table Across to Count of Order Quantity and Sort order by descending.
We successfully created one.
We forgot to add the Grand Total to complete this. To add Grand Total, Go to the Analysis Menu. Next, select the Totals option and the Show Row Grand Totals option.
The final preview of the Waterfall chart.
Comments are closed.