Tableau 2019.x Cookbook

How it works...

In step 1, we create a line chart with one dimension and one measure and then apply Running Total Table Calculation in step 2. In step 3, we then change the mark type to Gantt Bar. In order to create bars, in step 4, we negate the measure so each column can grow to the previous mark. This creates the stair step effect, so the end of one mark is the beginning of the previous one. We see in step 5 that we've created a basic waterfall chart.

In order to highlight the positive or negative change, we create a Dual Axis chart. In step 6, we duplicate the same measure on the Rows shelf. We clear the size from the second Marks card in step 7, which will emphasize the ending value when we make the dual axis in step 8—causing the marks ...