KNOWLEDGE BASE

Creating a Waterfall Chart with a Second Dimension on Color


Published: 18 Jul 2013
Last Modified Date: 03 Jan 2017

Question

How to create a waterfall chart with a second dimension on color.

Environment

Tableau Desktop

Answer

  1. Drag the first desired dimension to the Columns shelf.
  2. Drag the desired measure to the Rows shelf.
  3. Right-click the measure and select Quick Table Calculation > Running Total.
  4. Drag the second desired dimension to the Color shelf.
  5. On the Marks card select Gantt Bar from the mark type drop-down menu.
  6. Go to Analysis > Create Calculated Field... and create a calculation similar to the following:
    -sum([Measure])
  7. Drag this new calculate field to the Size shelf.
  8. From the Rows shelf, right-click on the measure and select Edit Table Calculation....
  9. Under Compute Using... select Specific Dimensions,  and check the boxes next to both dimensions.
  10. Close the  Table Calculation window.

Additional Information

To view these steps in action, see the video below. 
Note: video is silent.
Did this article resolve the issue?